Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BASEITEM
BaseItems represent a general family of goods with a common name and description. BaseItems are used exclusively for fulfillment. Each CatalogEntry that represents a Product in the catalog has a corresponding BaseItem for fulfillment purposes.
Column Name Column Type Description BASEITEM_ID BIGINT NOT NULL Generated unique key. MEMBER_ID BIGINT NOT NULL The owner of this BaseItem. ITEMTYPE_ID CHAR(4) NOT NULL The type of BaseItem. QUANTITYMEASURE CHAR(16) NOT NULL DEFAULT 'C62' The unit of measure for QUANTITYMULTIPLE. For example, to represent one quarter of an inch, QUANTITYMULTIPLE would be 0.25, and QUANTITYMEASURE would indicate the QTYUNIT that represents inches (normally INH). LASTUPDATE TIMESTAMP The last time this BaseItem was updated. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates whether a BaseItem has been marked for deletion:
0 = No, the BaseItem can be used.
1 = Yes, The BaseItem has been marked for deletion and cannot be used. Refer to the DBClean utility online help for more information.PARTNUMBER VARCHAR(72) NOT NULL Uniquely identifies a BaseItem for a particular owner. QUANTITYMULTIPLE DOUBLE NOT NULL DEFAULT 1.0 Amounts of this BaseItem are measured in integral units. QUANTITYMULTIPLE, along with QUANTITYMEASURE, indicates how much each integral unit represents. For example, textiles might be measured in integral units each representing one quarter of an inch. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000040 MEMBER_ID+PARTNUMBER Unique Index SQL100520030302080 BASEITEM_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_106 ITEMTYPE_ID ITEMTYPE ITEMTYPE_ID Cascade F_108 MEMBER_ID MEMBER MEMBER_ID Cascade F_107 QUANTITYMEASURE QTYUNIT QTYUNIT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_110 BASEITEM_ID BASEITMDSC BASEITEM_ID Cascade F_202 BASEITEM_ID CATENTRY BASEITEM_ID Cascade F_310 BASEITEM_ID DISTARRANG BASEITEM_ID Cascade F_407 BASEITEM_ID ITEMSPC BASEITEM_ID Cascade F_408 BASEITEM_ID ITEMVERSN BASEITEM_ID Cascade F_797 BASEITEM_ID STOREITEM BASEITEM_ID Cascade F_807 BASEITEM_ID STORITMFFC BASEITEM_ID Cascade
Related reference
- Dynamic kit data model
- Quantity unit - references data model
- Catalog entry data model
- ATP inventory data model
- ATP inventory fulfillment data model
- ATP inventory orders data model
_vcc_freeselect_bottom_