erd 아이템 수정본
테이블 (8)
CHARACTER_TYPES
- character_type_id — VARCHAR(250)
- type_name — VARCHAR(20) — NOT NULL
- collect_speed_mult — FLOAT
- inventory_slots — INT
- battery_drain_mult — FLOAT
- move_speed_mult — FLOAT
GAME_SESSIONS
- session_id — VARCHAR(250)
- host_player_id — VARCHAR(250) — NOT NULL
- player_count — INT
- map_seed — INT — NOT NULL
- status — VARCHAR(20)
- current_round — INT
- current_pollution_level — FLOAT
- created_at — TIMESTAMP
INVENTORY
- item_name — VARCHAR(50) — 외래 키 → ITEMS.item_name — NOT NULL
- inventory_id — VARCHAR(250)
- session_player_id — VARCHAR(250) — NOT NULL
- quantity — INT
- acquired_date — TIMESTAMP
ITEMS
- item_id — VARCHAR(250)
- item_name — VARCHAR(50) — NOT NULL
- item_type — VARCHAR(20) — NOT NULL
- base_price — INT
- buy_price — INT
- is_sellable — TINYINT(1)
- is_buyable — TINYINT(1)
- charge_amount — FLOAT
- price_fixed — TINYINT(1)
PLAYER
- character_type_id — VARCHAR(250) — 외래 키 → CHARACTER_TYPES.character_type_id
- player_id — VARCHAR(250)
- player_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- tutorial_completed — TINYINT(1)
- created_at — TIMESTAMP
ROUND_RESULTS
- mvp_player_id — VARCHAR(250) — 외래 키 → PLAYER.player_id
- round_result_id — VARCHAR(250)
- session_id — VARCHAR(250) — NOT NULL
- round_number — INT — NOT NULL
- pollution_reduced — FLOAT
- quota_achieved — TINYINT(1)
SESSION_PLAYERS
- player_id — VARCHAR(250) — 외래 키 → PLAYER.player_id
- session_player_id — VARCHAR(250)
- session_id — VARCHAR(250) — NOT NULL
- character_type_id — VARCHAR(250) — NOT NULL
- is_bot — TINYINT(1)
- current_battery — FLOAT
- gold — INT
- total_trash_collected — INT
- mvp_score — INT
TRADE_LOGS
- session_id — VARCHAR(250) — 외래 키 → GAME_SESSIONS.session_id — NOT NULL
- item_name — VARCHAR(50) — 외래 키 → ITEMS.item_name — NOT NULL
- trade_id — VARCHAR(250)
- player_id — VARCHAR(250) — NOT NULL
- npc_id — VARCHAR(250) — NOT NULL
- trade_type — VARCHAR(10) — NOT NULL
- quantity — INT
- gold_amount — INT
- gold_after — INT
- created_at — TIMESTAMP