OICONFIG

This table maintains the relationship between order item and its configuration details

Column Descriptions:

Name	Type	Description
OICONFIG_ID	BIGINT NOT NULL	Generated unique identifier
ORDERITEMS_ID	BIGINT NOT NULL	The OrderItem id to which this configuration is related.
CONFIGURATION	CLOB (1000000)	The detailed information of this configuration, typically, it may be an XML from external configurator.
FIELD1	VARCHAR (254)	Customizable
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	OICONFIG_ID	Primary Key
I0001412	ORDERITEMS_ID	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3712	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade