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:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe CatalogEntry.
WEIGHTDOUBLEA nominal weight associated with the product.
WEIGHTMEASURECHAR (16)The unit of measurement for WEIGHT.
LENGTHDOUBLEA nominal length associated with the product.
WIDTHDOUBLEA nominal width associated with the product.
HEIGHTDOUBLEA nominal height associated with the product.
SIZEMEASURECHAR (16)The unit of measurement for LENGTH, WIDTH, and HEIGHT.
NOMINALQUANTITYDOUBLE NOT NULL DEFAULT 1.0A 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.
QUANTITYMULTIPLEDOUBLE NOT NULL DEFAULT 1.0The product can be sold in quantities that are multiples of this quantity.
QUANTITYMEASURECHAR (16) NOT NULL DEFAULT 'C62'The unit of measurement for NOMINALQUANTITY and QUANTITYMULTIPLE.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENTRY_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_205CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_206QUANTITYMEASUREQTYUNITQTYUNIT_IDCascade
F_207SIZEMEASUREQTYUNITQTYUNIT_IDCascade
F_208WEIGHTMEASUREQTYUNITQTYUNIT_IDCascade