WebSphere Commerce database table: CNTRDISPLY

This table contains display information for a Contract.

Column Descriptions
Column Name Column Type Description
DEVICEFMT_ID INTEGER NOT NULL Device format identifier.
CNTRDISPLY_ID BIGINT NOT NULL Internal reference number. This is a primary key.
CONTRACT_ID BIGINT Contract ID. If null, this is the default display page.
PARTROLE_ID INTEGER Participant role. Allows a display page based on participant role.
DISPLAYPAGENAME VARCHAR(254) A display page name.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000075 CONTRACT_ID+DEVICEFMT_ID+PARTROLE_ID Unique Index
SQL060903235144290 CNTRDISPLY_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_246 CONTRACT_ID CONTRACT CONTRACT_ID Cascade
F_245 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade
F_244 PARTROLE_ID PARTROLE PARTROLE_ID Cascade
Related reference