Database Table: CNTRDISPLY

This table contains display information for a Contract.

Column Name Column Type Column Description
CNTRDISPLY_ID BIGINT
NOT NULL
Internal reference number. This is a primary key.
CONTRACT_ID BIGINT
NULL
Contract ID. If null, this is the default display page.
DEVICEFMT_ID INTEGER
NOT NULL
Device format identifier.
DISPLAYPAGENAME VARCHAR (254)
NULL
A display page name.
PARTROLE_ID INTEGER
NULL
Participant role. Allows a display page based on participant role.
Indexes:
Index Name Indexed Column Names Index Type
I0000075 CONTRACT_ID, DEVICEFMT_ID, PARTROLE_ID Unique Index
SQL030416034910030 CNTRDISPLY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_244 PARTROLE_ID PARTROLE PARTROLE_ID Cascade
F_245 DEVICEFMT_ID DEVICEFMT DEVICEFMT_ID Cascade
F_246 CONTRACT_ID CONTRACT CONTRACT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable