database
Tables (9)
Cart
- cart_id — INT — NOT NULL
- member_id — INT — Foreign key → Member.member_id
- product_id — INT — Foreign key → Product.product_id
- quantity — INT — NOT NULL
- is_wishlist — BOOLEAN
- added_at — TIMESTAMP
Category
- category_id — INT — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
Member
- member_id — INT — NOT NULL
- id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- birth_date — DATE — NOT NULL
- reward_points — INT
- status — VARCHAR(50)
- marketing_agree — BOOLEAN
- created_at — TIMESTAMP
- last_login_at — TIMESTAMP
Order_Item
- order_item_id — INT — NOT NULL
- order_id — INT — Foreign key → Order_Master.order_id
- product_id — INT — Foreign key → Product.product_id
- quantity — INT — NOT NULL
- order_price — INT — NOT NULL
Order_Master
- order_id — INT — NOT NULL
- member_id — INT — Foreign key → Member.member_id
- order_date — TIMESTAMP
- total_price — INT — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- payment_card_company — VARCHAR(100)
- payment_installment_months — INT
- payment_auth_no — VARCHAR(255)
- status — VARCHAR(50)
- shipping_company — VARCHAR(100)
- tracking_number — VARCHAR(255)
- shipping_address — TEXT — NOT NULL
- shipping_recipient — VARCHAR(255) — NOT NULL
- shipping_phone — VARCHAR(255) — NOT NULL
Product
- product_id — INT — NOT NULL
- category_id — INT — Foreign key → Category.category_id
- supplier_id — INT — Foreign key → Supplier.supplier_id
- name — VARCHAR(255) — NOT NULL
- unit_price — INT — NOT NULL
- stock — INT
- status — VARCHAR(50)
- specs — TEXT
- description — TEXT
- created_at — TIMESTAMP
Recent_View
- view_id — INT — NOT NULL
- member_id — INT — Foreign key → Member.member_id
- product_id — INT — Foreign key → Product.product_id
- view_date — TIMESTAMP
Review
- review_id — INT — NOT NULL
- member_id — INT — Foreign key → Member.member_id
- product_id — INT — Foreign key → Product.product_id
- rating — INT — NOT NULL
- content — TEXT
- image_url — VARCHAR(255)
- created_at — TIMESTAMP
Supplier
- supplier_id — INT — NOT NULL
- supplier_name — VARCHAR(255) — NOT NULL
- biz_no — VARCHAR(255)
- contact — VARCHAR(255)