CEDISPCONF

This table stores the configuration for catalog entry display properties. An example of such property is display sequence of a product under a category.

Column Descriptions:

Name	Type	Description
CEDISPCONF_ID	BIGINT NOT NULL	The internal reference number of the catalog entry display configuration.
CATENTRY_ID	BIGINT NOT NULL	The reference number that identifies a catalog entry. Along with the CEDISPCTX_ID and PROPERTY these columns are a unique index.
PROPERTY	VARCHAR (256) NOT NULL	Display property name. Valid values include 'Sequence' and 'Image'.  Along with the CATENTRY_ID and CEDISPCTX_ID these columns are a unique index.
VALUE	VARCHAR (256) NOT NULL	Display property value. This column holds the catalog entry identifier of the SKU whose image will be displayed for 'Image'' properties or a string representation of the sequence floating point number for 'Sequence' properties.
CEDISPCTX_ID	BIGINT NOT NULL	The reference number that identifies the contextual information of the catalog entry display configuration. Along with the CATENTRY_ID and PROPERTY these columns are a unique index.
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
P_0035	CEDISPCONF_ID	Primary Key
I0001527	CATENTRY_ID+PROPERTY+CEDISPCTX_ID	Unique Index
I0001528	CEDISPCTX_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3773	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_3774	CEDISPCTX_ID	CEDISPCTX	CEDISPCTX_ID	Cascade