20221223
Tables (4)
Admin (adm)
- Admin ID (id) — VARCHAR(10) — Primary key — NOT NULL
- Password (pwd) — VARCHAR(10)
- Level (lev) — INT
Customer (cust)
- Customer ID (id) — VARCHAR(10) — Primary key — NOT NULL
- Password (pwd) — VARCHAR(10)
- Name (name) — VARCHAR(10)
Product (item)
- Item No. (id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(20)
- Price (price) — INT
- Image Name (imgname) — VARCHAR(30)
- Register Date (rdate) — DATETIME
Shopping cart (cart)
- Cart No. (id) — INT — Primary key — NOT NULL
- Customer ID (cust_id) — VARCHAR(10) — Foreign key → Customer.Customer ID — NOT NULL
- Item No. (item_id) — INT — Foreign key → Product.Item No. — NOT NULL
- Item Count (cnt) — INT
- Register Date (rdate) — DATE