WebSphere Commerce database table: CATENTSHIP

Each row in this table contains information about how a product represented by a CatalogEntry is packaged. The information can be used to determine prices, discounts, shipping charges, and taxes.

Column Descriptions
Column Name Column Type Description
CATENTRY_ID BIGINT NOT NULL The CatalogEntry.
WEIGHT DOUBLE A nominal weight associated with the product.
WEIGHTMEASURE CHAR(16) The unit of measurement for WEIGHT.
LENGTH DOUBLE A nominal length associated with the product.
WIDTH DOUBLE A nominal width associated with the product.
HEIGHT DOUBLE A nominal height associated with the product.
SIZEMEASURE CHAR(16) The unit of measurement for LENGTH, WIDTH, and HEIGHT.
NOMINALQUANTITY DOUBLE NOT NULL DEFAULT 1.0 A nominal quantity for a product, used for pricing. For example, if a product is priced as "3 for a dollar", then the nominal quantity of the product is 3, and the price of the product is one dollar.
QUANTITYMULTIPLE DOUBLE NOT NULL DEFAULT 1.0 The product can be sold in quantities that are multiples of this quantity.
QUANTITYMEASURE CHAR(16) NOT NULL DEFAULT 'C62' The unit of measurement for NOMINALQUANTITY and QUANTITYMULTIPLE.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235138180 CATENTRY_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_205 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_206 QUANTITYMEASURE QTYUNIT QTYUNIT_ID Cascade
F_207 SIZEMEASURE QTYUNIT QTYUNIT_ID Cascade
F_208 WEIGHTMEASURE QTYUNIT QTYUNIT_ID Cascade
Related reference