title
Tables (3)
CUSTOMER
- Customer_ID — VARCHAR2(20) — Primary key — NOT NULL
- Customer_Name — VARCHAR2(10) — NOT NULL
- Customer_Age — INT
- Customer_Grade — VARCHAR2(10) — NOT NULL
- Customer_Job — VARCHAR2(20)
- Customer_Savings — INT
ORDERS
- Orders_Number — CHAR(3) — Primary key — NOT NULL
- Orders_Customer — VARCHAR2(20)REFERENCES
- Orders_Product — CHAR(3)REFERENCES
- Orders_Order_count — INT
- Orders_Area — VARCHAR2(30)
- Orders_Date — DATE
PRODUCTS
- Products_Number — CHAR — Primary key — NOT NULL
- Customer_ID — VARCHAR2(20) — Foreign key → CUSTOMER.Customer_ID — NOT NULL
- Products_Name — VARCHAR2(20)
- Products_Inventory — INT
- Products_Price — INT
- Products_Manufacturer — VARCHAR2(20)