shopping
Tables (4)
CUSTOMERS
- CNO (Primary key) — NOT NULL — Primary key — NOT NULL
- CNAME (Field) — NOT NULL
- ACCESS (Field2) — NOT NULL
- EMAIL (Field3) — NOT NULL
- PHONE (Field4) — NOT NULL
ORDERDETAIL
- ORDERNO (Key2) — NULL — Foreign key → ORDERS.ORDERNO — NOT NULL
- PNO (Key3) — NOT NULL — Foreign key → PRODUCTS.PNO — NOT NULL
- QTY (Field2) — NOT NULL
- COST (Field3) — NOT NULL
ORDERS
- ORDERNO (Key) — NULL — Primary key — NOT NULL
- ORDERDATE (Field) — NOT NULL
- ADDRESS (Field2) — NOT NULL
- PHONE (Field4) — NOT NULL
- STATUS (Field3) — NOT NULL
- CNO (Primary key) — NOT NULL — Foreign key → CUSTOMERS.CNO — NOT NULL
PRODUCTS
- PNO (Key) — Primary key — NOT NULL
- PNAME (Field) — NOT NULL
- COST (Field2) — NOT NULL
- STOCK (Field3) — NOT NULL