|
OE |
||||||||||||
|
Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
Description
Tracks availability of products by product_it and warehouse_id.
Columns
Primary key | Columns |
INVENTORY_PK | PRODUCT_ID, WAREHOUSE_ID |
Check constraint | Check condition |
INVENTORY_QOH_NN | "QUANTITY_ON_HAND" IS NOT NULL |
INVENTORY_WAREHOUSE_ID_NN | "WAREHOUSE_ID" IS NOT NULL |
Foreign key | Referenced table | Referenced constraint | Delete rule | Columns |
INVENTORIES_PRODUCT_ID_FK | PRODUCT_INFORMATION | PRODUCT_INFORMATION_PK | NO ACTION | PRODUCT_ID |
INVENTORIES_WAREHOUSES_FK | WAREHOUSES | WAREHOUSES_PK | NO ACTION | WAREHOUSE_ID |
Index | Type | Uniqueness | Columns |
INVENTORY_PK | NORMAL | UNIQUE | PRODUCT_ID, WAREHOUSE_ID |
INV_PRODUCT_IX | NORMAL | NONUNIQUE | PRODUCT_ID |
INV_WAREHOUSE_IX | NORMAL | NONUNIQUE | WAREHOUSE_ID |
Option | Setting |
Clustered | N |
Generated by Oracle | N |
Index Organized | N |
Logging | Y |
Partitioned | N |
Temporary | N |
Nested | N |