From dbscript Online Help
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]
