OICONFIG

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

Column Descriptions:

NameTypeDescription
OICONFIG_IDBIGINT NOT NULLGenerated unique identifier
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem id to which this configuration is related.
CONFIGURATIONCLOB (1000000)The detailed information of this configuration, typically, it may be an XML from external configurator.
FIELD1VARCHAR (254)Customizable
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>OICONFIG_IDPrimary Key
I0001412ORDERITEMS_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3712ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade