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:
| Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | CATENTRY_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |