CEDYNDISPCTX

Reserved for IBM internal use. This table holds the contextual information related to the configuration of the product dynamic sequence rule.


Column Descriptions:

Name Type Description
CEDYNDISPCTX_ID BIGINT NOT NULL The internal reference number of the catalog entry dynamic sequencing contextual information.
CATGROUP_ID BIGINT NOT NULL Catalog group for which the catalog entry dynamic sequencing configuration is defined.
STOREENT_ID INTEGER NOT NULL Foreign key to STOREENT table that represents the store for which this configuration is defined.
STARTTIME TIMESTAMP The start time of this configuration. The configuration with NULL start time is effective immediately.
LASTUPDATE TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP The time of the last update.
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_0041 CEDYNDISPCTX_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3779 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_3780 STOREENT_ID STOREENT STOREENT_ID Cascade


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_3781 CEDYNDISPCTX_ID CEDYNDISPCONF CEDYNDISPCTX_ID Cascade