Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DEVICEFMT
This table is for defining all the device format types.
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 SQL100520030323740 DEVICEFMT_ID Primary Key
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
Related reference
- Messaging data model
- Mobile device data model
- Catalog entry data model
- Catalog group data model
- Command data model
- Contract data model
_vcc_freeselect_bottom_