WebSphere Commerce database table: ITEMTYPE
Each row of this table represents a type of BaseItem.
Column Descriptions
| Column Name
| Column Type
| Description |
| ITEMTYPE_ID
| CHAR(4) NOT NULL
| Primary key. Only the following values are allowed:
ITEM = normal item.
DNKT = dynamic kit.
STKT = static kit.
|
| DESCRIPTION
| VARCHAR(254)
| A brief description of the ItemType.
|
| OID
| VARCHAR(64)
| Reserved for IBM internal use.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235209300
| ITEMTYPE_ID
| Primary Key
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_106
| ITEMTYPE_ID
| BASEITEM
| ITEMTYPE_ID
| Cascade
|
Related reference