테스트

테이블 (15)

command

  • command_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

command_option

  • option_id — BIGINT — 기본 키 — NOT NULL
  • command_id — BIGINT — 외래 키 → command.command_id — NOT NULL
  • option — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255) — NOT NULL

command_set

  • command_set_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL

command_set_item

  • item_id — BIGINT — 기본 키 — NOT NULL
  • command_set_id — BIGINT — 외래 키 → command_set.command_set_id — NOT NULL
  • command_sequence — INT — NOT NULL
  • text — VARCHAR(255) — NOT NULL
  • display_text — VARCHAR(255) — NOT NULL
  • branch_id — VARCHAR(100)

coop_game_player

  • id — BIGINT — 기본 키 — NOT NULL
  • result_id — BIGINT — 외래 키 → coop_game_result.result_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL

coop_game_result

  • result_id — BIGINT — 기본 키 — NOT NULL
  • map_id — BIGINT — 외래 키 → coop_map.map_id — NOT NULL
  • is_success — BOOLEAN — NOT NULL
  • elapsed_time — INT
  • played_at — DATETIME — NOT NULL

coop_map

  • map_id — BIGINT — 기본 키 — NOT NULL
  • map_name — VARCHAR(100) — NOT NULL
  • difficulty — ENUM('EASY', 'NORMAL', 'HARD') — NOT NULL
  • image_url — VARCHAR(255)
  • description — TEXT

coop_ranking

  • ranking_id — BIGINT — 기본 키 — NOT NULL
  • map_id — BIGINT — 외래 키 → coop_map.map_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • clear_time — INT — NOT NULL
  • result_id — BIGINT — 외래 키 → coop_game_result.result_id — NOT NULL
  • created_at — DATETIME — NOT NULL

game_record

  • record_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • mode — ENUM('SINGLE_EASY', 'SINGLE_NORMAL', 'SINGLE_HARD', 'SPEED_RUN', 'TIME_ATTACK') — NOT NULL
  • best_score — INT — NOT NULL
  • play_count — INT — NOT NULL

hall_of_fame

  • fame_id — BIGINT — 기본 키 — NOT NULL
  • mode — ENUM('SINGLE_EASY', 'SINGLE_NORMAL', 'SINGLE_HARD', 'SPEED_RUN', 'TIME_ATTACK') — NOT NULL
  • week — VARCHAR(10) — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • score — INT — NOT NULL
  • character_skin — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(50)
  • character_skin — VARCHAR(50)
  • character_asset — VARCHAR(50)
  • auth_type — ENUM('LOCAL', 'OAUTH') — NOT NULL
  • is_tutorial_done — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

multi_game_player_result

  • player_result_id — BIGINT — 기본 키 — NOT NULL
  • result_id — BIGINT — 외래 키 → multi_game_result.result_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • rank — INT — NOT NULL
  • score — INT — NOT NULL

multi_game_result

  • result_id — BIGINT — 기본 키 — NOT NULL
  • mode — ENUM('SPEED_RUN', 'TIME_ATTACK') — NOT NULL
  • command_set_id — BIGINT
  • played_at — DATETIME — NOT NULL

single_command_log

  • log_id — BIGINT — 기본 키 — NOT NULL
  • result_id — BIGINT — 외래 키 → single_game_result.result_id — NOT NULL
  • command_sequence — INT — NOT NULL
  • result — ENUM('HIT', 'MISS') — NOT NULL

single_game_result

  • result_id — BIGINT — 기본 키 — NOT NULL
  • session_id — VARCHAR(100) — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • command_set_id — BIGINT
  • difficulty — ENUM('EASY', 'NORMAL', 'HARD') — NOT NULL
  • score — INT — NOT NULL
  • grade — ENUM('S', 'A', 'B', 'C', 'D') — NOT NULL
  • play_time — INT — NOT NULL
  • max_combo — INT — NOT NULL
  • miss_count — INT — NOT NULL
  • status — ENUM('SUCCESS', 'GAMEOVER') — NOT NULL
  • played_at — DATETIME — NOT NULL