Footprints Data Model

Table
Table Name Item Field Collection
Table Definition Holds an unordered collection of string field values for an Item. Used for picklists and multiple selections. All multiselect fields are stored here. This table can be implemented as a global system table, container-level table, or item-level table. Currently it is a system level table.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Id A Foreign Key to the Item table. LONG Yes
String Value The value of a Item Field Collection, stored as a string. VARCHAR(255) Yes
Item Field Definition Id A Foreign Key to the Definition table for an instance of type Item Field Definition. LONG Yes