Subject Area : 051 - Item Field Collection
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 051 - Item Field Collection This shows the table for multi-select fields. Details.. Details..
ER Diagram(s) of Subject Area "051 - Item Field Collection"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "051 - Item Field Collection"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 5
. item Item true true The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance. Details..
. item_defn Item Definition true true The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names. Details..
. item_field Item Field true true A place related to a specific item that stores or displays data. Details..
. item_field_coll Item Field Collection false 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. Details..
. item_field_defn Item Field Definition true true Item Field Definition is an association between the Item Definition entity and the Field Definition entity. This association contains a distinct value for each of the intersection points between the two entities. Details..
Attribute/Column(s) of Entity/Table "Item"
# Physical Name Name Definition Physical Data Type
Total 4
. item_key Item Key A search key for the Item, composed of letters and numbers. varchar(255)
. item_id Item Id The automatically generated primary key of the item table. bigint
. cntnr_id Container Id A Foreign Key to the Container table. bigint
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "Item Definition"
# Physical Name Name Definition Physical Data Type
Total 2
. item_table_name Item Table Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
Attribute/Column(s) of Entity/Table "Item Field"
# Physical Name Name Definition Physical Data Type
Total 1
. item_id Item Id A Foreign Key to the Item table. bigint
Attribute/Column(s) of Entity/Table "Item Field Collection"
# Physical Name Name Definition Physical Data Type
Total 3
. item_id Item Id A Foreign Key to the Item table. bigint
. string_val String Value The value of a Item Field Collection, stored as a string. varchar(255)
. item_field_defn_id Item Field Definition Id A Foreign Key to the Definition table for an instance of type Item Field Definition. bigint
Attribute/Column(s) of Entity/Table "Item Field Definition"
# Physical Name Name Definition Physical Data Type
Total 3
. item_field_defn_id Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
. field_defn_id Field Definition Id A Foreign Key to the Definition table. bigint