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)