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:

NameTypeDescription
CEDISPCONF_IDBIGINT NOT NULLThe internal reference number of the catalog entry display configuration.
CATENTRY_IDBIGINT NOT NULLThe reference number that identifies a catalog entry. Along with the CEDISPCTX_ID and PROPERTY these columns are a unique index.
PROPERTYVARCHAR (256) NOT NULLDisplay property name. Valid values include 'Sequence' and 'Image'.  Along with the CATENTRY_ID and CEDISPCTX_ID these columns are a unique index.
VALUEVARCHAR (256) NOT NULLDisplay 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_IDBIGINT NOT NULLThe 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0035CEDISPCONF_IDPrimary Key
I0001527CATENTRY_ID+PROPERTY+CEDISPCTX_IDUnique Index
I0001528CEDISPCTX_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3773CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_3774CEDISPCTX_IDCEDISPCTXCEDISPCTX_IDCascade