Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

OE
Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

INVENTORIES

Description

Tracks availability of products by product_it and warehouse_id.

Columns

Column Datatype Nullable Default value Comment
PRODUCT_ID NUMBER(6,0) N   Part of concatenated primary key, references product_information.product_id.
WAREHOUSE_ID NUMBER(3,0) N   Part of concatenated primary key, references warehouses.warehouse_id.
QUANTITY_ON_HAND NUMBER(8,0) N    

Primary key

Primary key Columns
INVENTORY_PK PRODUCT_ID, WAREHOUSE_ID

Check constraints

Check constraint Check condition
INVENTORY_QOH_NN "QUANTITY_ON_HAND" IS NOT NULL
INVENTORY_WAREHOUSE_ID_NN "WAREHOUSE_ID" IS NOT NULL

Foreign keys

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

Indexes

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

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized N
Logging Y
Partitioned N
Temporary N
Nested N

Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005