컴공 판타지 아이템 쇼핑몰 기획서
테이블 (6)
cart_items
- id — INT
- user_id — INT — 외래 키 → users.id — NOT NULL
- item_id — INT — 외래 키 → items.id — NOT NULL
- quantity — INT — NOT NULL
categories
- id — INT
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- parent_category_id — INT — 외래 키 → categories.id
- display_order — INT
items
- id — INT
- name — VARCHAR(150) — NOT NULL
- price — INT — NOT NULL
- description — VARCHAR(1000)
- rarity — VARCHAR(50) — NOT NULL
- stat_int — INT — NOT NULL
- stat_str — INT — NOT NULL
- stat_dex — INT — NOT NULL
- stat_lck — INT — NOT NULL
- cs_tag — VARCHAR(100)
- stock_quantity — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- category_id — INT — 외래 키 → categories.id — NOT NULL
order_items
- id — INT
- order_id — INT — 외래 키 → orders.id — NOT NULL
- item_id — INT — 외래 키 → items.id — NOT NULL
- item_name_snapshot — VARCHAR(150) — NOT NULL
- rarity_snapshot — VARCHAR(50) — NOT NULL
- stat_int_snapshot — INT — NOT NULL
- stat_str_snapshot — INT — NOT NULL
- stat_dex_snapshot — INT — NOT NULL
- stat_lck_snapshot — INT — NOT NULL
- cs_tag_snapshot — VARCHAR(100)
- quantity — INT — NOT NULL
- unit_price — INT — NOT NULL
- subtotal_price — INT — NOT NULL
orders
- id — INT
- user_id — INT — 외래 키 → users.id — NOT NULL
- total_price — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- payment_method — VARCHAR(50)
- shipping_address — VARCHAR(500)
- shipping_memo — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — INT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL