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