WebSphere Commerce database table: CATENTTYPE

This table defines all possible types of CatalogEntries. Examples of CatalogEntry types are ProductBean, ItemBean, PackageBean, BundleBean and DynamicKitBean.


Column Description(s):
Column NameColumn TypeDescription
CATENTTYPE_ID CHAR(16) NOT NULL The identifier of this CatalogEntry type.
DESCRIPTION VARCHAR(254) The description for this CatalogEntry type.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031209360 CATENTTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_204 CATENTTYPE_ID CATENTRY CATENTTYPE_ID Cascade
F_307 CATENTTYPE_ID DISPENTREL CATENTTYPE_ID Cascade

Feedback