테스트
테이블 (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