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