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
|
|
SUPPLIER
|
||
SUPPLIER_ID
|
NUHBER
|
NOT NULL, Primary Key
|
SUPPLIER_NAME
|
VARCHAR2(25)
|
|
ADDRESS
|
VARCHAR2(30)
|
|
CITY
|
VARCHAR2(25)
|
|
REGION
|
VARCHAR2(10)
|
|
POSTAL_CODE
|
VARCHAR2(11)
|
|