shopping mall

Tables (4)

CUSTOMERS

  • CNO — NUMBER — Primary key — NOT NULL
  • CNAME — VARCHAR2
  • ADDRESS — VARCHAR2
  • EMAIL — VARCHAR2
  • PHONE — VARCHAR2

ORDERDETAIL

  • ORDERNO — NUMBER — Primary key — NOT NULL
  • PNO — NUMBER — Primary key — NOT NULL
  • QTY — NUMBER
  • COST — NUMBER
  • ORDERNO (ORDERNO2) — NUMBER — Foreign key → ORDERS.ORDERNO — NOT NULL
  • PNO (PNO2) — NUMBER — Foreign key → PRODUCTS.PNO — NOT NULL

ORDERS

  • ORDERNO — NUMBER — Primary key — NOT NULL
  • ORDERDATE — VARCHAR2
  • ADDRESS — VARCHAR2
  • PHONE — VARCHAR2
  • STATUS — VARCHAR2
  • CNO (CNO2) — NUMBER — Foreign key → CUSTOMERS.CNO — NOT NULL

PRODUCTS

  • PNO — NUMBER — Primary key — NOT NULL
  • PNAME — VARCHAR2
  • COST — NUMBER
  • STOCK — NUMBER