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)