Database View: STOREINV

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).
Indexes:
Index Name Indexed Column Names Index Type
Not Applicable
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

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