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