sss
Tables (10)
Carts
- id — INT
- user_id — INT — NOT NULL
- product_variant_id — INT — NOT NULL
- quantity — INT — NOT NULL
- created_at — TIMESTAMP
Order_Items
- id — INT
- order_id — INT — Foreign key → Orders.id — NOT NULL
- product_id — INT — Foreign key → Products.id — NOT NULL
- variant_name — VARCHAR(100) — 주문 당시 옵션명 스냅샷
- order_price — DECIMAL(10, 2) — NOT NULL — 주문 당시 가격 스냅샷' CHECK (order_price >= 0
- quantity — INT — NOT NULL
- created_at — TIMESTAMP
Orders
- id — VARCHAR(50)
- user_id — INT — NOT NULL
- 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
Payments
- id — INT
- order_id — INT — Foreign key → Orders.id — NOT NULL
- method — VARCHAR(20) — NOT NULL
- 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 — BOOLEAN
- sort_order — INT
- INDEX — idx_product_id
Products
- id — INT
- category_id — INT — 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
- INDEX — idx_category_id
Reviews
- id — INT
- product_id — INT — Foreign key → Products.id — NOT NULL
- user_id — INT — 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
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 — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_user_id
categories
- id — INT
- parent_id — INT — Foreign key → categories.id
- name — VARCHAR(50) — NOT NULL
- depth — INT
- INDEX — idx_parent_id
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