WebSphere Commerce database table: PVCDEVMDL

This table stores device model information. Records will be looked up by the value returned by the WebSphere Commerce pervasive computing adapter. Each subclass of PVCAdapterImpl is responsible to get a device model name from the HTTP request.

Column Descriptions
Column Name Column Type Description
MODEL_ID INTEGER NOT NULL Reference number.
MODELNAME VARCHAR(40) The model name. An empty string means default for devices which have the same SESSION_TYPE. This column is deprecated and is provided for backward compatibility only.
SESSIONTYPE VARCHAR(32) NOT NULL Type of carrier. For example, iMode.
VENDOR VARCHAR(80) Vendor name of this model.
DESCRIPTION VARCHAR(128) Short description of the device model.
DEVMDLNAME VARCHAR(128) The model name. A NULL value means default for devices which have the same SESSION_TYPE.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000195 DEVMDLNAME+SESSIONTYPE Unique Index
SQL060903235237760 MODEL_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_637 MODEL_ID PVCMDLSPEC MODEL_ID Cascade
Related reference