shopping

Tables (4)

CUSTOMERS

  • CNO (Primary key) — NOT NULL — Primary key — NOT NULL
  • CNAME (Field) — NOT NULL
  • ACCESS (Field2) — NOT NULL
  • EMAIL (Field3) — NOT NULL
  • PHONE (Field4) — NOT NULL

ORDERDETAIL

  • ORDERNO (Key2) — NULL — Foreign key → ORDERS.ORDERNO — NOT NULL
  • PNO (Key3) — NOT NULL — Foreign key → PRODUCTS.PNO — NOT NULL
  • QTY (Field2) — NOT NULL
  • COST (Field3) — NOT NULL

ORDERS

  • ORDERNO (Key) — NULL — Primary key — NOT NULL
  • ORDERDATE (Field) — NOT NULL
  • ADDRESS (Field2) — NOT NULL
  • PHONE (Field4) — NOT NULL
  • STATUS (Field3) — NOT NULL
  • CNO (Primary key) — NOT NULL — Foreign key → CUSTOMERS.CNO — NOT NULL

PRODUCTS

  • PNO (Key) — Primary key — NOT NULL
  • PNAME (Field) — NOT NULL
  • COST (Field2) — NOT NULL
  • STOCK (Field3) — NOT NULL