ShoppingMall erd

Tables (4)

CUSTOMERS

  • CNO — varchar — Primary key — NOT NULL
  • CNAME — varchar
  • ADDRESS — varchar
  • EMAIL — varchar
  • PHONE — varchar

ORDERDETAIL

  • QTY — varchar
  • COST — number
  • ORDERNO — number — Foreign key → ORDERS.ORDERNO — NOT NULL
  • PNO — varchar — Foreign key → PRODUCTS.PNO — NOT NULL

ORDERS

  • ORDERNO — number — Primary key — NOT NULL
  • ORDERDATE — date
  • ADDRESS — varchar
  • PHONE — varchar
  • STATUS — varchar
  • Field
  • CNO — varchar — Foreign key → CUSTOMERS.CNO — NOT NULL

PRODUCTS

  • PNO — varchar — Primary key — NOT NULL
  • PNAME — varchar
  • COST — number
  • STOCK — number