Contact

Tables (4)

Customers (customers)

  • Cno (cno) — varchar(5) — Primary key — NOT NULL
  • Cname (cname) — varchar(10)
  • ADRESS (adress) — varchar(50)
  • EMAIL (email) — varchar(20)
  • PHONE (phone) — varchar(20)

Orderdetail (orderdetail)

  • Key — Primary key — NOT NULL
  • ORDERNO (orderno2) — varchar(10) — Foreign key → Orders.ORDERNO — NOT NULL
  • PNO (pno2) — varchar(5) — Foreign key → Product.PNO — NOT NULL
  • ORDERNO (orderno) — varchar(10) — Foreign key → Orders.ORDERNO — NOT NULL
  • PNO (pno) — varchar(5) — Foreign key → Product.PNO — NOT NULL

Orders (orders)

  • ORDERNO (orderno) — varchar(10) — Primary key — NOT NULL
  • ORDERDATE (orderdate) — varchar(8)
  • ADDRESS (address) — varchar(50)
  • PHONE (phone) — varchar(20)
  • STATUS (status) — varchar(5)
  • Cno (cno) — varchar(5) — Foreign key → Customers.Cno — NOT NULL

Product (product)

  • PNO (pno) — varchar(5) — Primary key — NOT NULL
  • PNAME (pname) — varchar(20)
  • COST (cost) — int(8)
  • STOCK (stock) — varchar(10)