WebSphere Commerce database table: DEVICEFMT
This table is for defining all the device format types.
Column Descriptions Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL060903235150190 DEVICEFMT_ID Primary Key Related reference
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