Reference > Database > WebSphere Commerce database tables > C


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 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
SQL100520030321760 CPPMNVAL_ID Primary Key

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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search