s
Tables (6)
cart_items
- cart_item_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.member_id — NOT NULL
- product_id — bigint — Foreign key → products.product_id — NOT NULL
- quantity — int — NOT NULL
categories
- category_id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL — 카테고리명
- display_order — int — NOT NULL — 표시 순서
- is_active — tinyint(1) — NOT NULL — 활성 여부
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
members
- member_id — bigint — Primary key — NOT NULL
- username — varchar(40) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- phone — varchar(30) — NOT NULL
order_items
- order_item_id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → orders.order_id — NOT NULL
- product_id — bigint — Foreign key → products.product_id — NOT NULL
- quantity — int — NOT NULL
orders
- order_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.member_id — NOT NULL
- payment_token — varchar(255)
- paid_at — datetime — NOT NULL
- shipping_address — varchar(255) — NOT NULL
- total_amount — decimal(12,0) — NOT NULL
products
- product_id — bigint — Primary key — NOT NULL
- name — varchar(120) — NOT NULL
- price — decimal(10, 0) — NOT NULL
- stock_qty — int — NOT NULL
- category_id — bigint — Foreign key → categories.category_id — 카테고리 ID
- options — varchar(10)
- image_file_name — varchar(255)
- updated_at — timestamp
- created_at — timestamp