Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: OICOMPREL
Stores all kit level information for an Order item that is a kit. A kit may contain other kits and catalog entries outside of a kit. This table stores information about kit components and the OICOMPLIST table stores information about catalog entries outside of a kit.
Column Name Column Type Description OICOMPREL_ID BIGINT NOT NULL Unique primary key. ORDERITEMS_ID BIGINT The OrderItem Id for this instance of the top level kit, now that it is part of an Order. ITEMSPC_ID BIGINT NOT NULL The Item specification for this kit entry. PARENT_ID BIGINT Pointer to the parent kit. It is NULL if the entry is the top level kit. REQUIRED SMALLINT DEFAULT 1 Indicates if this kit is required or optional to complete the parent kit. OPTCOUNTER SMALLINT Reserved for IBM internal use. CONFIGURATION_ID VARCHAR(128) If the top level kit is a dynamic kit, this value indicates the external Id assigned by the configurator to this kit. A dynamic kit can only contain other dynamic kits, not prebuilt nor static kits.
Indexes Index Name Indexed Column Names Index Type SQL100520030358560 OICOMPREL_ID Primary Key I0000963 ITEMSPC_ID Non-Unique Index I0000964 PARENT_ID Non-Unique Index I0000966 ORDERITEMS_ID Non-Unique Index I0001101 CONFIGURATION_ID+ORDERITEMS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1229 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade F_1228 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1074 OICOMPREL_ID OICOMPLIST OICOMPREL_ID Cascade _vcc_freeselect_bottom_