Reference > Database > WebSphere Commerce database tables > P
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 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 SQL100520030415650 MODEL_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_637 MODEL_ID PVCMDLSPEC MODEL_ID Cascade
Related reference
_vcc_freeselect_bottom_