This summary table contains pre-computed sums for quantity amount for each CatalogEntry in a Store. It contains precomputed results based on data existing in underlying INVENTORY table its definition is based on.
Column Name | Column Type | Column Description |
---|---|---|
C5 | INTEGER NOT NULL |
Count of the number of rows. Required by definition of summary tables. |
CATENTRY_ID | BIGINT NOT NULL |
The CatalogEntry identifier. It is CATENTRY_ID found in INVENTORY table. |
QUANTITYMEASURE | CHARACTER (16) NOT NULL |
The unit of measurement for QUANTITY. It is QUANTITYMEASURE found in INVENTORY table. |
STOREQUANTITY | DOUBLE NULL |
Inventory quantity for entire store. This is a computed value based on QUANTITY across all FulfillmentCenters found in INVENTORY table. |
STORE_ID | INTEGER NOT NULL |
The Store (value for STORE_ID found in the INVENTORY table). |
Index Name | Indexed Column Names | Index Type |
---|---|---|
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|