Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CNTRDISPLY
This table contains display information for a Contract.
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 SQL100520030318130 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
_vcc_freeselect_bottom_