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:
Name | Type | Description |
CATENTRY_ID | BIGINT NOT NULL | The catalog entries that this configuration
information applies to. Typically, the type of the catalog entries
will be DynamicKitBean. |
URL | VARCHAR (254) | The URL location of an external product
configurator. |
REFERENCE | VARCHAR (4000) | Reference information that is required by an
external product configurator. |
FIELD1 | INTEGER | Customizable. |
FIELD2 | DOUBLE | Customizable. |
FIELD3 | VARCHAR (254) | Customizable. |
FIELD4 | VARCHAR (254) | Customizable. |
FIELD5 | TIMESTAMP | Customizable. |
CONFIGURATION | CLOB (1000000) | The detailed information of this configuration,
typically, it may be an XML from external configurator. |
CONFIGURABLE | SMALLINT DEFAULT 1 | Indicates whether a predefined dynamic kit is
configurable. Not applicable for other catalog entry types.
- 0: Not configurable
- 1: Configurable
|
OPTCOUNTER | SMALLINT | 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> | CATENTRY_ID | Primary Key |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_189 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |