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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000075 | CONTRACT_ID, DEVICEFMT_ID, PARTROLE_ID | Unique Index |
SQL030416034910030 | CNTRDISPLY_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|