Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_CDPOOL
This table contains all the promotion codes available to shoppers.
Column Name Column 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. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001313 CODE+STORE_ID Unique Index SQL100520030706240 PX_CDPOOL_ID Primary Key I0001314 STORE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3605 STORE_ID STORE STORE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3607 PX_CDPOOL_ID PX_CDPROMO PX_CDPOOL_ID Cascade F_3608 PX_CDPOOL_ID PX_CDUSAGE PX_CDPOOL_ID Cascade _vcc_freeselect_bottom_