This table stores device model information. Records
will be looked up by the value returned by the HCL Commerce
pervasive computing adapter. Each subclass of PVCAdapterImpl is
responsible to get a device model name from the HTTP request.
Column Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | MODEL_ID | Primary Key |
I0000195 | DEVMDLNAME+SESSIONTYPE | Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_637 | MODEL_ID | PVCMDLSPEC | MODEL_ID | Cascade |