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 Column Description
DESCRIPTION VARCHAR (128)
NULL
Short description of the device model.
DEVMDLNAME VARCHAR (128)
NULL
The model name. A NULL value means default for devices which have the same SESSION_TYPE.
MODELNAME VARCHAR (40)
NULL
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.
MODEL_ID INTEGER
NOT NULL
Reference number.
SESSIONTYPE VARCHAR (32)
NOT NULL
Type of carrier. For example, iMode.
VENDOR VARCHAR (80)
NULL
Vendor name of this model.
Indexes:
Index Name Indexed Column Names Index Type
I0000195 DEVMDLNAME, SESSIONTYPE Unique Index
SQL030416035042860 MODEL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_637 MODEL_ID PVCMDLSPEC MODEL_ID Cascade