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 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> | CATENTRY_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_189 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |