PX_CDPOOL
All the promotion codes available to shoppers.
Column Descriptions:
Name Type Description PX_CDPOOL_ID BIGINT NOT NULL Primary key. STORE_ID INTEGER NOT NULL Foreign key to STORE. USAGETYPE SMALLINT NOT NULL DEFAULT 0 0: Private, single use
1: Public, multiple usesCODE VARCHAR (128) NOT NULL The code string. STATUS SMALLINT NOT NULL 0: Inactive
1: Active
2: Mark for delete
TRANSFERABLE SMALLINT NOT NULL DEFAULT 0 0: Transferring allowed
1: Transferring not allowedVALIDFROM TIMESTAMP Currently not in use. VALIDUNTIL TIMESTAMP Currently not in use. REFERENCE_ID BIGINT DEFAULT NULL The unique identifier of the promotion that has the code associated with it. INTERNAL_ID BIGINT DEFAULT 0 For unique promotion codes, this column will always have a value of 0 to ensure that the same code is not used in another promotion in the store. For public promotion codes, this column will have a unique value to allow multiple promotions to share the same code. WORKSPACE VARCHAR (25) This column will have the value 'IBM_WC_BASE' to indicate that the unique promotion codes are present in base schema. When the codes are generated from the context of a workspace, this column will hold the name of the workspace. TASKGROUP VARCHAR (25) When the codes are generated from the context of a workspace, this column will hold the name of the taskgroup. 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> PX_CDPOOL_ID Primary Key I0001313 CODE+STORE_ID+INTERNAL_ID Unique Index I0001314 STORE_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_3605 STORE_ID STORE STORE_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_3607 PX_CDPOOL_ID PX_CDPROMO PX_CDPOOL_ID Cascade F_3608 PX_CDPOOL_ID PX_CDUSAGE PX_CDPOOL_ID Cascade