DEVICEFMT

This table is for defining all the device format types.

Column Descriptions:

NameTypeDescription
DEVICETYPE_IDCHAR (64) NOT NULLDevice type ID.
DEVICEFMT_IDINTEGER NOT NULLDevice format ID. The default device format is -1, which t represents an HTTP Web browser.
DISPLAYNAMEVARCHAR (254) NOT NULLDisplay name for the device format.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DEVICEFMT_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_245DEVICEFMT_IDCNTRDISPLYDEVICEFMT_IDCascade
F_300DEVICEFMT_IDDISPCGPRELDEVICEFMT_IDCascade
F_306DEVICEFMT_IDDISPENTRELDEVICEFMT_IDCascade
F_626DEVICEFMT_IDPROFILEDEVICEFMT_IDCascade
F_892DEVICEFMT_IDUSERPVCDEVDEVICEFMT_IDCascade