WebSphere Commerce database table: CATENTTYPE

This table defines all possible types of catalog entries. Examples of catalog entry types are ProductBean, ItemBean, PackageBean, BundleBean and DynamicKitBean.

Column Descriptions
Column Name Column Type Description
CATENTTYPE_ID CHAR(16) NOT NULL The identifier of this catalog entry type.
DESCRIPTION VARCHAR(254) The description for this catalog entry type.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235138320 CATENTTYPE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_204 CATENTTYPE_ID CATENTRY CATENTTYPE_ID Cascade
F_307 CATENTTYPE_ID DISPENTREL CATENTTYPE_ID Cascade