Each row of this table represents a type of BaseItem.
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031235370 | ITEMTYPE_ID | Primary Key |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_106 | ITEMTYPE_ID | BASEITEM | ITEMTYPE_ID | Cascade |