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