ShoppingMall erd
Tables (4)
CUSTOMERS
- CNO — varchar — Primary key — NOT NULL
- CNAME — varchar
- ADDRESS — varchar
- EMAIL — varchar
- PHONE — varchar
ORDERDETAIL
- QTY — varchar
- COST — number
- ORDERNO — number — Foreign key → ORDERS.ORDERNO — NOT NULL
- PNO — varchar — Foreign key → PRODUCTS.PNO — NOT NULL
ORDERS
- ORDERNO — number — Primary key — NOT NULL
- ORDERDATE — date
- ADDRESS — varchar
- PHONE — varchar
- STATUS — varchar
- Field
- CNO — varchar — Foreign key → CUSTOMERS.CNO — NOT NULL
PRODUCTS
- PNO — varchar — Primary key — NOT NULL
- PNAME — varchar
- COST — number
- STOCK — number