Corazy Arcade ERD
Tables (22)
algorithm
- id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
auth_provider
- id — BIGINT — NOT NULL
- name — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
chat_message
- id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_room_created_at
chat_room
- id — BIGINT — NOT NULL
- type — VARCHAR(10) — NOT NULL
- name — VARCHAR(100)
- owner_id — BIGINT
- created_at — DATETIME — NOT NULL
chat_room_member
- id — BIGINT — NOT NULL
- room_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- joined_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
dictation
- id — BIGINT — NOT NULL
- algorithm_id — BIGINT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
dictation_answer
- id — BIGINT — NOT NULL
- dictation_id — BIGINT — NOT NULL
- language_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
dictation_best_data
- id — BIGINT — NOT NULL
- best_accuracy — TINYINT — NOT NULL
- best_cpm — INT — NOT NULL
- best_wpm — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- dictation_id — BIGINT — NOT NULL
- updated_at — DATETIME — NOT NULL
- user_id — BIGINT — NOT NULL
dictation_result
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- dictation_id — BIGINT — NOT NULL
- wpm — INT — NOT NULL
- cpm — INT — NOT NULL
- acc — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
game_participant
- id — BIGINT — NOT NULL
- game_result_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- turn_order — INT — NOT NULL
- code_contribution — TEXT
- duration_seconds — INT
- created_at — DATETIME — NOT NULL
game_result
- id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL
- language_id — BIGINT — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- total_participants — INT — NOT NULL
- final_code — TEXT — NOT NULL
- is_success — BOOLEAN — NOT NULL
- solved_by_user_id — BIGINT
- total_turns — INT — NOT NULL
- total_duration_seconds — INT — NOT NULL
- started_at — DATETIME — NOT NULL
- completed_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
membership
- id — BIGINT — NOT NULL
- grade — VARCHAR(15) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
problem
- id — BIGINT — NOT NULL
- problem_number — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
problem_algorithm
- id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL
- algorithm_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
problem_language
- id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL
- language_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
programming_language
- id — BIGINT — NOT NULL
- language — VARCHAR(15) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
refresh_token
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- token — VARCHAR(255) — NOT NULL
- issued_ip — VARCHAR(50)
- issued_user_agent — VARCHAR(255)
- expired_at — DATETIME — NOT NULL
term
- id — BIGINT — NOT NULL
- title — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
term_version
- id — BIGINT — NOT NULL
- term_id — BIGINT — NOT NULL
- major_version — TINYINT — NOT NULL
- minor_version — TINYINT — NOT NULL
- content — TEXT — NOT NULL
- mandatory — BOOLEAN — NOT NULL
- effective_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
user_agreement
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- term_version_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
user_authentication
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- provider_id — BIGINT — NOT NULL
- provided_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
users
- id — BIGINT — NOT NULL
- membership_id — BIGINT — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(20) — NOT NULL
- password — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL