WebSphere Commerce database table: CPPMNVAL

Reserved for IBM internal use. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.

Column Descriptions
Column Name Column Type Description
CPPMNVAL_ID INTEGER NOT NULL Reserved for IBM internal use.
STARTTIME TIMESTAMP Reserved for IBM internal use.
ENDTIME TIMESTAMP Reserved for IBM internal use.
DAY CHAR(72) Reserved for IBM internal use.
WEEK CHAR(40) Reserved for IBM internal use.
MONTH CHAR(32) Reserved for IBM internal use.
VALIDITYTYPE CHAR(1) Reserved for IBM internal use.
FIELD1 VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235148220 CPPMNVAL_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_267 CPPMNVAL_ID CPPMN CPPMNVAL_ID Cascade
Related reference