Database Table: DEVICEFMT

This table is for defining all the device format types.

Column Name Column Type Column Description
DEVICEFMT_ID INTEGER
NOT NULL
Device format ID. The default device format is -1 that represents an HTTP Web browser.
DEVICETYPE_ID CHARACTER (64)
NOT NULL
Device type ID.
DISPLAYNAME VARCHAR (254)
NOT NULL
Display name for the device format.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034921480 DEVICEFMT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_245 DEVICEFMT_ID CNTRDISPLY DEVICEFMT_ID Cascade
F_300 DEVICEFMT_ID DISPCGPREL DEVICEFMT_ID Cascade
F_306 DEVICEFMT_ID DISPENTREL DEVICEFMT_ID Cascade
F_626 DEVICEFMT_ID PROFILE DEVICEFMT_ID Cascade
F_892 DEVICEFMT_ID USERPVCDEV DEVICEFMT_ID Cascade
F_908 DEVICEFMT_ID VIEWREG DEVICEFMT_ID Cascade