WebSphere Commerce database table: DEVICEFMT

This table is for defining all the device format types.


Column Description(s):
Column NameColumn TypeDescription
DEVICETYPE_ID CHAR(64) NOT NULL Device type ID.
DEVICEFMT_ID INTEGER NOT NULL Device format ID. The default device format is -1, which t represents an HTTP Web browser.
DISPLAYNAME VARCHAR(254) NOT NULL Display name for the device format.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031220650 DEVICEFMT_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback