WebSphere Commerce database table: ITEMTYPE

Each row of this table represents a type of BaseItem.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031235370 ITEMTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_106 ITEMTYPE_ID BASEITEM ITEMTYPE_ID Cascade

Feedback