Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PX_CDSPEC
This table contains addition promotion code information.
Column Name Column Type Description PX_PROMOTION_ID INTEGER NOT NULL Primary key. Foreign key to PX_PROMOTION. CODETYPE SMALLINT NOT NULL DEFAULT 0 0: Public code
1: Basic generated code
2: Advanced generated code
3: Imported code
PATTERN VARCHAR(128) Pattern for advanced code. COUNT BIGINT Number of total codes to be generated. CODESTATUS SMALLINT NOT NULL DEFAULT 0 0: Not populated
1: Populated
2: Processing
3: Canceled
4: Generation failed
5: Importing failedTRANSFERABLE 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 SQL100520030706520 PX_PROMOTION_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3604 PX_PROMOTION_ID PX_PROMOTION PX_PROMOTION_ID Cascade _vcc_freeselect_bottom_