Reference > Database > WebSphere Commerce database tables > C
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 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 SQL100520030311360 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
_vcc_freeselect_bottom_