nada2
Tables (9)
carts
- id — INT
- member_id — INT — Foreign key → users.id
- product_id — INT — Foreign key → products.id
- option_id — INT
- quantity — INT
categories
- id — INT
- name — VARCHAR(100)
- parent_id — INT
order_items
- id — INT
- order_id — INT — Foreign key → orders.id
- product_id — INT — Foreign key → products.id
- option_id — INT
- quantity — INT
- sale_price — INT
orders
- id — INT
- member_id — INT — Foreign key → users.id
- total_price — INT
- status — VARCHAR(50)
- recipient_name — VARCHAR(100)
- recipient_phone — VARCHAR(20)
- zip_code — VARCHAR(10)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- used_point — INT
- created_at — DATETIME
points
- id — INT
- member_id — INT — Foreign key → users.id
- amount — INT
- reason — VARCHAR(255)
- created_at — DATETIME
product_options
- id — INT
- product_id — INT — Foreign key → products.id
- name — VARCHAR(100)
- value — VARCHAR(100)
- add_price — INT
- stock_qty — INT
products
- id — INT
- category_id — INT — Foreign key → categories.id
- name — VARCHAR(255)
- base_price — INT
- description — TEXT
- image_url — VARCHAR(500)
- is_display — BOOLEAN
- created_at — DATETIME
reviews
- id — INT
- member_id — INT — Foreign key → users.id
- product_id — INT — Foreign key → products.id
- order_id — INT
- content — TEXT
- rating — INT
- created_at — DATETIME
users
- id — INT
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(100)
- phone — VARCHAR(20)
- grade — VARCHAR(20)
- role — VARCHAR(20)
- created_at — DATETIME