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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034901250 | CATENTRY_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|