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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000195 | DEVMDLNAME, SESSIONTYPE | Unique Index |
SQL030416035042860 | MODEL_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_637 | MODEL_ID | PVCMDLSPEC | MODEL_ID | Cascade |