ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
OE.INVENTORIES_(table)
Print
RSS
Modified: 2011/08/27 11:08 by
wikibot
-
Uncategorized
»
OE.INVENTORIES_(table)
[X]
»
OE.INVENTORIES_(table)
Edit
wikibot
Table
OE.INVENTORIES
Description
Tracks availability of products by product_it and warehouse_id.
Edit
Columns
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
Edit
Primary Key
Primary Key
Columns
INVENTORY_IX
WAREHOUSE_ID, PRODUCT_ID
Edit
Indexes
Index
Type
Columns
INV_PRODUCT_IX
PRODUCT_ID
Edit
Check Constraints
Check Constraint
Expression
Description
INVENTORY_QOH_NN
"QUANTITY_ON_HAND" IS NOT NULL
INVENTORY_WAREHOUSE_ID_NN
"WAREHOUSE_ID" IS NOT NULL
Edit
Foreign Keys
Relation
Column
Referenced Column
OE.PRODUCT_INFORMATION
PRODUCT_ID
PRODUCT_ID
OE.WAREHOUSES
WAREHOUSE_ID
WAREHOUSE_ID
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.