|
PRODUCT
|
||
|
PRODUCT_ID
|
NUMBER
|
NOT NULL, Primary Key
|
|
PRODUCT_NAME
|
VARCHAR2(25)
|
|
|
SUPPLIER_ID
|
NUMBER
|
Foreign key to SUPPLIER_ID of the SUPPLIER table
|
|
LIST_PRICE
|
NUMBER(7, 2)
|
|
|
COST
|
NUMBER(7, 2)
|
|
|
QTY_IN_STOCK
|
NUMBER
|
|
|
QTY_ON_ORDER
|
NUMBER
|
|
|
REORDER_LEVEL
|
NUMBER
|
|
|
REORDER_QTY
|
NUMBER
|
|