PX_CDPOOL

This table contains 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 uses
CODE	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 allowed
VALIDFROM	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