WebSphere Commerce database table: OICOMPREL

Stores all the kit level information for an Order Item that is a kit that contains other kits. 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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031242210 OICOMPREL_ID Primary Key
I0000963 ITEMSPC_ID Non-Unique Index
I0000964 PARENT_ID Non-Unique Index
I0000966 ORDERITEMS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1229 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_1228 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1074 OICOMPREL_ID OICOMPLIST OICOMPREL_ID Cascade

Feedback