Each row of this table represents a type of BaseItem.
Column Name | Column Type | Column Description |
---|---|---|
DESCRIPTION | VARCHAR (254) NULL |
A brief description of the ItemType. |
ITEMTYPE_ID | CHARACTER (4) NOT NULL |
Primary key. Only the following values are allowed: ITEM = normal item. DNKT = dynamic kit. STKT = static kit. |
OID | VARCHAR (64) NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034949880 | ITEMTYPE_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_106 | ITEMTYPE_ID | BASEITEM | ITEMTYPE_ID | Cascade |