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