shop

Tables (4)

CUSTOMERS

  • CNO — number(5) — Primary key — NOT NULL
  • CNAME — varchar2(10) — NOT NULL
  • ADDRESS — varchar2(50) — NOT NULL
  • EMAIL — varchar2(20) — NOT NULL
  • PHONE — varchar2(20) — NOT NULL

ORDERDETAIL

  • PNO — number(5) — Foreign key → PRODUCTS.PNO — NOT NULL
  • ORDERNO — number(10) — Foreign key → ORDERS.ORDERNO — NOT NULL
  • QTY — number(5)
  • COST — number(8)

ORDERS

  • ORDERNO — number(10) — Primary key — NOT NULL
  • CNO — number(5) — Foreign key → CUSTOMERS.CNO — NOT NULL
  • ORDERDATE — date — NOT NULL
  • ADDRESS — varchar2(50) — NOT NULL
  • PHONE — varchar2(20) — NOT NULL
  • STATUS — varchar2(20) — NOT NULL

PRODUCTS

  • PNO — number(5) — Primary key — NOT NULL
  • PNAME — varchar2(20) — NOT NULL
  • COST — number(8) — NOT NULL
  • STOCK — number(5) — NOT NULL