shopping mall
Tables (4)
CUSTOMERS
- CNO — NUMBER — Primary key — NOT NULL
- CNAME — VARCHAR2
- ADDRESS — VARCHAR2
- EMAIL — VARCHAR2
- PHONE — VARCHAR2
ORDERDETAIL
- ORDERNO — NUMBER — Primary key — NOT NULL
- PNO — NUMBER — Primary key — NOT NULL
- QTY — NUMBER
- COST — NUMBER
- ORDERNO (ORDERNO2) — NUMBER — Foreign key → ORDERS.ORDERNO — NOT NULL
- PNO (PNO2) — NUMBER — Foreign key → PRODUCTS.PNO — NOT NULL
ORDERS
- ORDERNO — NUMBER — Primary key — NOT NULL
- ORDERDATE — VARCHAR2
- ADDRESS — VARCHAR2
- PHONE — VARCHAR2
- STATUS — VARCHAR2
- CNO (CNO2) — NUMBER — Foreign key → CUSTOMERS.CNO — NOT NULL
PRODUCTS
- PNO — NUMBER — Primary key — NOT NULL
- PNAME — VARCHAR2
- COST — NUMBER
- STOCK — NUMBER