OE.INVENTORIES (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table OE.INVENTORIES
Description Tracks availability of products by product_it and warehouse_id.

Columns[edit]

Column Data Type Nullable Default Description
PRODUCT_ID NUMBER(6, 0) not null Part of concatenated primary key, references product_information.product_id.
WAREHOUSE_ID NUMBER(3, 0) not null Part of concatenated primary key, references warehouses.warehouse_id.
QUANTITY_ON_HAND NUMBER(8, 0) not null

Primary Key[edit]

Primary Key Columns
INVENTORY_IX WAREHOUSE_ID, PRODUCT_ID

Indexes[edit]

Index Type Columns
INV_PRODUCT_IX PRODUCT_ID

Check Constraints[edit]

Check Constraint Expression Description
INVENTORY_QOH_NN "QUANTITY_ON_HAND" IS NOT NULL
INVENTORY_WAREHOUSE_ID_NN "WAREHOUSE_ID" IS NOT NULL

Foreign Keys[edit]

Relation Column Referenced Column
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID
OE.WAREHOUSES WAREHOUSE_ID WAREHOUSE_ID