erd(사이고)
테이블 (14)
ACHIEVEMENTS
- achievement_id — VARCHAR(250) — NOT NULL
- achievement_name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- condition_type — VARCHAR(50) — NOT NULL
- condition_value — INT — NOT NULL
- condition_weather — VARCHAR(30)
CHARACTER_TYPES
- character_type_id — VARCHAR(250) — NOT NULL
- type_name — VARCHAR(20) — NOT NULL
- collect_speed_mult — FLOAT — NOT NULL
- inventory_slots — INT — NOT NULL
- plant_speed_mult — FLOAT — NOT NULL
- plant_growth_mult — FLOAT — NOT NULL
- gold_gain_mult — FLOAT — NOT NULL
- battery_drain_mult — FLOAT — NOT NULL
- move_speed_mult — FLOAT — NOT NULL
COMMON_CODES
- code_no — VARCHAR(250) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- code_name — VARCHAR(100) — NOT NULL
ENVIRONMENTS
- environment_id — VARCHAR(250) — NOT NULL
- weather_name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- battery_drain_multiplier — FLOAT — NOT NULL
GAME_SESSIONS
- session_id — VARCHAR(250) — 기본 키 — NOT NULL
- host_player_id — VARCHAR(250) — 기본 키 — NOT NULL
- player_id — VARCHAR(250) — 외래 키 → PLAYER.player_id — NOT NULL
- player_count — INT — NOT NULL
- map_seed — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- current_round — INT — NOT NULL
- current_pollution_level — FLOAT — NOT NULL
- game_over_reason — VARCHAR(50)
- created_at — TIMESTAMP
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
INVENTORY
- inventory_id — VARCHAR(250) — NOT NULL
- session_player_id — VARCHAR(250) — 외래 키 → SESSION_PLAYERS.session_player_id — NOT NULL
- item_name — VARCHAR(50) — 외래 키 → ITEMS.item_name — NOT NULL
- quantity — INT — NOT NULL
- acquired_date — TIMESTAMP
- player_id (player_id2) — VARCHAR(250) — 외래 키 — NOT NULL
- host_player_id — VARCHAR(250) — 외래 키 — NOT NULL
- session_id (session_id2) — VARCHAR(250) — 외래 키 — NOT NULL
- session_id — VARCHAR(250) — 외래 키 → SESSION_PLAYERS.session_id — NOT NULL
- host_player_id (host_player_id2) — VARCHAR(250) — 외래 키 → SESSION_PLAYERS.host_player_id — NOT NULL
- session_player_id (session_player_id2) — VARCHAR(250) — 외래 키 → SESSION_PLAYERS.session_player_id — NOT NULL
ITEMS
- item_id — VARCHAR(250) — NOT NULL
- item_name — VARCHAR(50) — NOT NULL
- item_type — VARCHAR(20) — NOT NULL
- base_price — INT — NOT NULL
- buy_price — INT — NOT NULL
- is_sellable — TINYINT(1) — NOT NULL
- is_buyable — TINYINT(1) — NOT NULL
LARGE_WASTE_OBJECTS
- waste_id — VARCHAR(250) — 기본 키 — NOT NULL
- destroyed_by_player_id — VARCHAR(250) — 외래 키 → PLAYER.player_id
- map_id — VARCHAR(250) — 외래 키 → MAPS.map_id — NOT NULL
- pos_x — FLOAT — NOT NULL
- pos_y — FLOAT — NOT NULL
- is_destroyed — TINYINT(1)
- destroyed_at — TIMESTAMP
MAPS
- map_id — VARCHAR(250) — 기본 키 — NOT NULL
- session_id — VARCHAR(250) — 외래 키 → GAME_SESSIONS.session_id — NOT NULL
- map_seed — INT — NOT NULL
- active_range — INT
- pollution_level — FLOAT
- tree_count — INT
- picked_trash_count — INT
- trash_spawn_interval — FLOAT
- max_trash_count — INT
- player_count_modifier — FLOAT
- elapsed_days — INT
NPCS
- npc_id — VARCHAR(250) — NOT NULL
- npc_name — VARCHAR(50) — NOT NULL
- zone_type — VARCHAR(30) — NOT NULL
- pos_x — FLOAT
- pos_y — FLOAT
NPC_INTERACTIONS
- interaction_id — VARCHAR(250) — NOT NULL
- npc_id — VARCHAR(250
PLAYER
- player_id — VARCHAR(250) — 기본 키 — NOT NULL
- character_type_id — VARCHAR(250) — 외래 키 → CHARACTER_TYPES.character_type_id
- player_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- tutorial_completed — TINYINT(1) — NOT NULL
- tutorial_last_step — INT — NOT NULL
- created_at — TIMESTAMP
SESSION_PLAYERS
- session_player_id — VARCHAR(250) — 기본 키 — NOT NULL
- player_id — VARCHAR(250) — 외래 키 → PLAYER.player_id
- character_type_id — VARCHAR(250) — 외래 키 → CHARACTER_TYPES.character_type_id — NOT NULL
- session_id — VARCHAR(250) — 외래 키 → GAME_SESSIONS.session_id — NOT NULL
- host_player_id — VARCHAR(250) — 외래 키 → GAME_SESSIONS.host_player_id — NOT NULL
- is_bot — TINYINT(1) — NOT NULL
- is_ready — TINYINT(1) — NOT NULL
- current_battery — FLOAT — NOT NULL
- gold — INT — NOT NULL
- pos_x — FLOAT
- pos_y — FLOAT
- is_knocked_out — TINYINT(1) — NOT NULL
- total_trash_collected — INT
- total_trees_planted — INT
- total_large_waste_removed — INT
- total_gold_earned — INT
TRADE_LOGS
- trade_id — VARCHAR(250) — 기본 키 — NOT NULL
- player_id — VARCHAR(250) — 외래 키 → PLAYER.player_id — NOT NULL
- npc_id — VARCHAR(250) — 외래 키 → NPCS.npc_id — NOT NULL
- session_id — VARCHAR(250) — 외래 키 → GAME_SESSIONS.session_id — NOT NULL
- host_player_id — VARCHAR(250) — 외래 키 → GAME_SESSIONS.host_player_id — NOT NULL
- trade_type — VARCHAR(10) — NOT NULL
- item_name — VARCHAR(50) — NOT NULL
- quantity — INT
- gold_amount — INT
- gold_after — INT
- created_at — TIMESTAMP