K-unirank

Tables (18)

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(10) — NOT NULL
  • selection_category — VARCHAR(100) — NOT NULL
  • metric_code — VARCHAR(100) — NOT NULL
  • aggregation_method — VARCHAR(30) — NOT NULL
  • value — DECIMAL(14,5) — NOT NULL
  • sample_count — INT — NOT NULL
  • calculated_at — DATETIME — NOT NULL

admission_metrics

  • metric_id — BIGINT — Primary key — NOT NULL
  • result_id — BIGINT — Foreign key → admission_results.result_id — NOT NULL
  • metric_code — VARCHAR(100) — NOT NULL
  • unit — VARCHAR(50) — NOT NULL
  • value — DECIMAL(14,5) — NOT NULL

admission_results

  • result_id — BIGINT — Primary key — NOT NULL
  • source_id — BIGINT — Foreign key → admission_sources.source_id — 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
  • admission_year — INT — NOT NULL
  • admission_phase — VARCHAR(10) — NOT NULL
  • selection_category — VARCHAR(100) — NOT NULL
  • selection_name — VARCHAR(200) — NOT NULL
  • recruitment_group — VARCHAR(30) — NOT NULL
  • recruitment_count — INT
  • applicant_count — INT
  • registered_count — INT
  • competition_rate — DECIMAL(10,3)

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(20) — NOT NULL
  • source_url — VARCHAR(1000) — NOT NULL
  • document_title — VARCHAR(300) — NOT NULL
  • collected_at — DATETIME — NOT NULL
  • checksum — VARCHAR(64) — NOT NULL

auth_user

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(150) — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • first_name — VARCHAR(150) — NOT NULL
  • last_name — VARCHAR(150) — NOT NULL
  • email — VARCHAR(254) — NOT NULL
  • is_staff — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_superuser — BOOLEAN — NOT NULL
  • last_login — DATETIME
  • date_joined — DATETIME — NOT NULL

comparison_votes

  • vote_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → ranking_boards.board_id — NOT NULL
  • session_id — CHAR(36) — Foreign key → vote_sessions.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

favorite_recruitment_units

  • favorite_recruitment_unit_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
  • recruitment_unit_id — BIGINT — Foreign key → recruitment_units.recruitment_unit_id — NOT NULL
  • created_at — DATETIME — NOT NULL

favorite_universities

  • favorite_university_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → auth_user.id — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • created_at — DATETIME — NOT NULL

personal_results

  • result_id — CHAR(36) — Primary key — NOT NULL
  • session_id — CHAR(36) — Foreign key → vote_sessions.session_id — NOT NULL
  • board_id — BIGINT — Foreign key → ranking_boards.board_id — NOT NULL
  • vote_count — INT — NOT NULL
  • result_json — JSON — NOT NULL
  • created_at — DATETIME — NOT NULL

ranking_boards

  • board_id — BIGINT — Primary key — NOT NULL
  • slug — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ranking_snapshot_items

  • 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
  • rank — INT — NOT NULL
  • rating — DOUBLE — NOT NULL
  • match_count — BIGINT — NOT NULL

ranking_snapshots

  • snapshot_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → ranking_boards.board_id — NOT NULL
  • snapshot_date — DATE — NOT NULL
  • total_votes — BIGINT — 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
  • campus_id — BIGINT — Foreign key → university_campuses.campus_id
  • name — VARCHAR(200) — NOT NULL
  • college_name — VARCHAR(200) — NOT NULL
  • is_active — BOOLEAN — NOT NULL

universities

  • university_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • short_name — VARCHAR(100)
  • address — VARCHAR(255)
  • region — VARCHAR(100)
  • university_type — VARCHAR(100)
  • establishment_type — VARCHAR(50)
  • homepage_url — VARCHAR(500)
  • college_info_url — VARCHAR(1000)
  • logo_path — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

university_campuses

  • campus_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
  • campus_name — VARCHAR(150)
  • address — VARCHAR(255)
  • region — VARCHAR(100)
  • homepage_url — VARCHAR(500)
  • is_primary — 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
  • campus_id — BIGINT — Foreign key → university_campuses.campus_id
  • source — VARCHAR(50) — NOT NULL
  • external_code — VARCHAR(100) — NOT NULL
  • external_name — VARCHAR(200)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

university_ratings

  • rating_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → ranking_boards.board_id — NOT NULL
  • university_id — BIGINT — Foreign key → universities.university_id — NOT NULL
  • rating — DOUBLE — NOT NULL
  • rating_deviation — DOUBLE — NOT NULL
  • volatility — DOUBLE — NOT NULL
  • match_count — BIGINT — NOT NULL
  • win_count — BIGINT — NOT NULL
  • loss_count — BIGINT — NOT NULL
  • updated_at — DATETIME — NOT NULL

vote_sessions

  • session_id — CHAR(36) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → auth_user.id
  • session_key — VARCHAR(64) — NOT NULL
  • ip_hash — VARCHAR(64) — NOT NULL
  • vote_count — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • last_seen_at — DATETIME — NOT NULL