Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: ITEMTYPE
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.
Indexes Index Name Indexed Column Names Index Type SQL100520030348150 ITEMTYPE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_106 ITEMTYPE_ID BASEITEM ITEMTYPE_ID Cascade
Related reference
_vcc_freeselect_bottom_