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