ssss
Tables (10)
addresses
- id — INT
- user_id — INT — Foreign key → users.id — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- address_main — VARCHAR(255) — NOT NULL
- address_detail — VARCHAR(255)
- zipcode — VARCHAR(10)
- is_default — TINYINT(1)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
carts
- id — INT
- user_id — INT — Foreign key → users.id — NOT NULL
- product_id — INT — Foreign key → products.id — NOT NULL
- quantity — INT — NOT NULL
- created_at — TIMESTAMP
categories
- id — INT
- parent_id — INT — Foreign key → categories.id
- name — VARCHAR(50) — NOT NULL
- depth — INT
- INDEX — idx_parent_id
order_items
- id — INT
- order_id — INT — Foreign key → orders.id — NOT NULL
- product_id — INT — Foreign key → products.id — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- variant_name — VARCHAR(100) — 주문 당시 옵션명 스냅샷
- order_price — DECIMAL(10, 2) — NOT NULL
- quantity — INT — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_order_id
- INDEX — idx_product_id
orders
- id — INT
- user_id — INT — Foreign key → users.id — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- address_main — VARCHAR(255) — NOT NULL
- address_detail — VARCHAR(255)
- zipcode — VARCHAR(10)
- phone — VARCHAR(20)
- total_amount — DECIMAL(12, 2) — NOT NULL
- order_status — ENUM('PENDING', 'PAID', 'SHIPPING', 'DELIVERED', 'CANCELLED')
- delivery_message — TEXT
- ordered_at — TIMESTAMP
- INDEX — idx_user_id
- INDEX — idx_ordered_at
- INDEX — idx_status
payments
- id — INT
- order_id — INT — Foreign key → orders.id — NOT NULL
- method — ENUM('cash', 'points', 'card') — NOT NULL
- status — ENUM('PENDING', 'SUCCESS', 'FAILED', 'REFUNDED')
- transaction_id — VARCHAR(100)
- amount — DECIMAL(10, 2) — NOT NULL
- paid_at — TIMESTAMP
product_images
- id — INT
- product_id — INT — Foreign key → products.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- is_thumbnail — TINYINT(1)
- sort_order — INT
- INDEX — idx_product_id
products
- id — INT
- category_id — INT — Foreign key → categories.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- base_price — DECIMAL(12, 2) — NOT NULL
- status — ENUM('ACTIVE', 'SOLD_OUT', 'HIDDEN')
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_category_id
- INDEX — idx_status
reviews
- id — INT
- product_id — INT — Foreign key → products.id — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- order_item_id — INT — Foreign key → order_items.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- image_url — VARCHAR(500)
- created_at — TIMESTAMP
- INDEX — idx_product_rating
users
- id — INT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- role — ENUM('CUSTOMER', 'ADMIN')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP