Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: 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 Name Column 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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030310190 CATENTRY_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_189 CATENTRY_ID CATENTRY CATENTRY_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search