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 |