INVENTORY
|
||||||
Column Name
|
ID_HUMBER
|
DESCRIPTION
|
MANUFACTURER_ID
|
QUANTITY
|
PRICE
|
ORDER_DATE
|
Key Type
|
PK
|
|
FK
|
|
|
|
Nulls/Unique
|
HN, U
|
NN
|
NN
|
|
|
|
FK Table
|
|
|
MANUFACTURER
|
|
|
|
FK Column
|
|
|
ID_NUMBER
|
|
|
|
Datatype
|
NUM
|
VARCHAR2
|
VARCHAR2
|
NUM
|
HUM
|
DATE
|
Length
|
9
|
25
|
26
|
9
|
8, 2
|
|