WebSphere Commerce database table: CNTRDISPLY

This table contains display information for a Contract.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000075 CONTRACT_ID+DEVICEFMT_ID+PARTROLE_ID Unique Index
SQL050212031215250 CNTRDISPLY_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback