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 |