CATCONFINF

This table holds additional information for catalog entries that represent configurable products. This information may be required by an external configurator to configure this catalog entries.

Column Descriptions:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe catalog entries that this configuration information applies to. Typically, the type of the catalog entries will be DynamicKitBean.
URLVARCHAR (254)The URL location of an external product configurator.
REFERENCEVARCHAR (4000)Reference information that is required by an external product configurator.
FIELD1INTEGERCustomizable.
FIELD2DOUBLECustomizable.
FIELD3VARCHAR (254)Customizable.
FIELD4VARCHAR (254)Customizable.
FIELD5TIMESTAMPCustomizable.
CONFIGURATIONCLOB (1000000)The detailed information of this configuration, typically, it may be an XML from external configurator.
CONFIGURABLESMALLINT DEFAULT 1Indicates whether a predefined dynamic kit is configurable. Not applicable for other catalog entry types.
  • 0: Not configurable
  • 1: Configurable
OPTCOUNTERSMALLINTThe 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>CATENTRY_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_189CATENTRY_IDCATENTRYCATENTRY_IDCascade