Database Table: ITEMTYPE

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034949880 ITEMTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_106 ITEMTYPE_ID BASEITEM ITEMTYPE_ID Cascade