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 Column Description
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry.
HEIGHT DOUBLE
NULL
A nominal height associated with the product.
LENGTH DOUBLE
NULL
A nominal length associated with the product.
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.
QUANTITYMEASURE CHARACTER (16)
NOT NULL, DEFAULT 'C62'
The unit of measurement for NOMINALQUANTITY and QUANTITYMULTIPLE.
QUANTITYMULTIPLE DOUBLE
NOT NULL, DEFAULT 1.0
The product can be sold in quantities that are multiples of this quantity.
SIZEMEASURE CHARACTER (16)
NULL
The unit of measurement for LENGTH, WIDTH, and HEIGHT.
WEIGHT DOUBLE
NULL
A nominal weight associated with the product.
WEIGHTMEASURE CHARACTER (16)
NULL
The unit of measurement for WEIGHT.
WIDTH DOUBLE
NULL
A nominal width associated with the product.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034901250 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable