Footprints Data Model

Table
Name item_field_coll
Comment 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.

Column
Name Datatype Comment Is PK Is FK
item_id bigint A Foreign Key to the Item table. Yes Yes
item_field_defn_id bigint A Foreign Key to the Definition table for an instance of type Item Field Definition. Yes Yes
string_val varchar(255) The value of a Item Field Collection, stored as a string. Yes No