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 |