PX_CDPOOL

This table contains all the promotion codes available to shoppers.

Column Descriptions:

NameTypeDescription
PX_CDPOOL_IDBIGINT NOT NULLPrimary key.
STORE_IDINTEGER NOT NULLForeign key to STORE.
USAGETYPESMALLINT NOT NULL DEFAULT 00: Private, single use 1: Public, multiple uses
CODEVARCHAR (128) NOT NULLThe code string.
STATUSSMALLINT NOT NULL0: Inactive 1: Active 2: Mark for delete
TRANSFERABLESMALLINT NOT NULL DEFAULT 00: Transferring allowed 1: Transferring not allowed
VALIDFROMTIMESTAMPCurrently not in use.
VALIDUNTILTIMESTAMPCurrently not in use.
REFERENCE_IDBIGINT DEFAULT NULLThe unique identifier of the promotion that has the code associated with it.
INTERNAL_IDBIGINT DEFAULT 0For 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.
WORKSPACEVARCHAR (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.
TASKGROUPVARCHAR (25)When the codes are generated from the context of a workspace, this column will hold the name of the taskgroup.
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
<SYSTEM-GENERATED>PX_CDPOOL_IDPrimary Key
I0001313CODE+STORE_ID+INTERNAL_IDUnique Index
I0001314STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3605STORE_IDSTORESTORE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3607PX_CDPOOL_IDPX_CDPROMOPX_CDPOOL_IDCascade
F_3608PX_CDPOOL_IDPX_CDUSAGEPX_CDPOOL_IDCascade