K-unirank

Tables (15)

admission_aggregates

  • aggregate_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • admission_year — INT — NOT NULL
  • admission_phase — VARCHAR(20) — NOT NULL
  • selection_category — VARCHAR(50) — NOT NULL
  • metric_code — VARCHAR(100) — NOT NULL
  • aggregation_method — VARCHAR(50) — NOT NULL
  • value — DECIMAL(12, 4) — NOT NULL
  • sample_count — INT — NOT NULL
  • calculated_at — DATETIME — NOT NULL

admission_metrics

  • metric_id — BIGINT — Primary key — NOT NULL
  • admission_result_id — BIGINT — Foreign key → admission_results.admission_result_id — NOT NULL
  • metric_code — VARCHAR(100) — NOT NULL
  • metric_unit — VARCHAR(50) — NOT NULL
  • metric_value — DECIMAL(12, 4) — NOT NULL

admission_results

  • admission_result_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • recruitment_unit_id — BIGINT — Foreign key → recruitment_units.recruitment_unit_id — NOT NULL
  • source_id — BIGINT — Foreign key → admission_sources.source_id — NOT NULL
  • admission_year — INT — NOT NULL
  • admission_phase — VARCHAR(20) — NOT NULL
  • selection_category — VARCHAR(50) — NOT NULL
  • selection_name — VARCHAR(200) — NOT NULL
  • recruitment_group — VARCHAR(20)
  • recruitment_count — INT
  • applicant_count — INT
  • registered_count — INT
  • competition_rate — DECIMAL(10, 3)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

admission_sources

  • source_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • admission_year — INT — NOT NULL
  • source_type — VARCHAR(50) — NOT NULL
  • source_url — VARCHAR(1000)
  • document_title — VARCHAR(500)
  • collected_at — DATETIME — NOT NULL
  • checksum — VARCHAR(128)

auth_accounts

  • auth_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

comparison_votes

  • vote_id — BIGINT — Primary key — NOT NULL
  • ranking_board_id — BIGINT — Foreign key → ranking_boards.ranking_board_id — NOT NULL
  • vote_session_id — BIGINT — Foreign key → vote_sessions.vote_session_id — NOT NULL
  • university_a_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • university_b_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • selected_university_id — BIGINT — Foreign key → universities.university_id
  • skipped — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

ranking_boards

  • ranking_board_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • ranking_year — INT — NOT NULL
  • algorithm — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL

ranking_snapshot_items

  • snapshot_item_id — BIGINT — Primary key — NOT NULL
  • snapshot_id — BIGINT — Foreign key → ranking_snapshots.snapshot_id — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • ranking_position — INT — NOT NULL
  • rating — DECIMAL(10, 4) — NOT NULL
  • win_rate — DECIMAL(5, 2)

ranking_snapshots

  • snapshot_id — BIGINT — Primary key — NOT NULL
  • ranking_board_id — BIGINT — Foreign key → ranking_boards.ranking_board_id — NOT NULL
  • snapshot_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

recruitment_units

  • recruitment_unit_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • normalized_name — VARCHAR(200)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

universities

  • university_id — BIGINT — Primary key — NOT NULL
  • parent_university_id — BIGINT — Foreign key → universities.university_id
  • name — VARCHAR(150) — NOT NULL
  • short_name — VARCHAR(100)
  • campus_name — VARCHAR(100)
  • region — VARCHAR(100)
  • university_type — VARCHAR(50)
  • logo_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

university_external_mappings

  • mapping_id — BIGINT — Primary key — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • external_code — VARCHAR(100) — NOT NULL
  • external_name — VARCHAR(200)

university_ratings

  • rating_id — BIGINT — Primary key — NOT NULL
  • ranking_board_id — BIGINT — Foreign key → ranking_boards.ranking_board_id — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • rating — DECIMAL(10, 4) — NOT NULL
  • rating_deviation — DECIMAL(10, 4)
  • volatility — DECIMAL(10, 6)
  • match_count — BIGINT — NOT NULL
  • win_count — BIGINT — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

vote_sessions

  • vote_session_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • session_key — VARCHAR(255) — NOT NULL
  • ip_hash — VARCHAR(255)
  • started_at — DATETIME — NOT NULL
  • last_active_at — DATETIME — NOT NULL