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