personalized re-ranking
Tables (16)
competition
- competition_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- category — VARCHAR(100)
- host — VARCHAR(200)
- description — TEXT
- application_start_date — DATE
- application_end_date — DATE
- image_url — VARCHAR(500)
- source_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
competition_recommendation
- competition_recommendation_id — BIGINT
- run_id — BIGINT — Foreign key → recommendation_run.run_id — NOT NULL
- competition_id — BIGINT — Foreign key → competition.competition_id — NOT NULL
- match_score — DECIMAL(5,2) — NOT NULL
- rank_order — INT — NOT NULL
- reason_summary — VARCHAR(500)
competition_required_role
- required_role_id — BIGINT
- competition_id — BIGINT — Foreign key → competition.competition_id — NOT NULL
- role_name — VARCHAR(50) — NOT NULL
- required_count — INT — NOT NULL
- description — VARCHAR(255)
competition_skill
- competition_skill_id — BIGINT
- competition_id — BIGINT — Foreign key → competition.competition_id — NOT NULL
- skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
- importance_weight — DECIMAL(5,2) — NOT NULL
cv_file
- cv_file_id — BIGINT
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- original_file_name — VARCHAR(255) — NOT NULL
- saved_file_url — VARCHAR(500) — NOT NULL
- file_type — VARCHAR(30)
- parsed_text — LONGTEXT
- uploaded_at — DATETIME — NOT NULL
member
- member_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- major — VARCHAR(100)
- grade — VARCHAR(20)
- profile_image_url — VARCHAR(500)
- member_role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member_skill
- member_skill_id — BIGINT
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
- source — VARCHAR(30) — NOT NULL
- confidence_score — DECIMAL(5,2)
- created_at — DATETIME — NOT NULL
member_survey_answer
- answer_id — BIGINT
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- question_id — BIGINT — Foreign key → survey_question.question_id — NOT NULL
- option_id — BIGINT — Foreign key → survey_option.option_id
- answer_text — VARCHAR(500)
- created_at — DATETIME — NOT NULL
recommendation_run
- run_id — BIGINT
- request_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- target_competition_id — BIGINT — Foreign key → competition.competition_id
- recommendation_type — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
skill
- skill_id — BIGINT
- skill_name — VARCHAR(100) — NOT NULL
- skill_type — VARCHAR(50) — NOT NULL
survey_option
- option_id — BIGINT
- question_id — BIGINT — Foreign key → survey_question.question_id — NOT NULL
- option_text — VARCHAR(255) — NOT NULL
- option_value — VARCHAR(100)
- score — INT
- option_order — INT — NOT NULL
survey_question
- question_id — BIGINT
- section_id — BIGINT — Foreign key → survey_section.section_id — NOT NULL
- question_text — VARCHAR(500) — NOT NULL
- question_type — VARCHAR(30) — NOT NULL
- max_select_count — INT
- question_order — INT — NOT NULL
survey_section
- section_id — BIGINT
- section_code — VARCHAR(50) — NOT NULL
- section_name — VARCHAR(100) — NOT NULL
- step_order — INT — NOT NULL
team
- team_id — BIGINT
- competition_id — BIGINT — Foreign key → competition.competition_id — NOT NULL
- created_by_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- team_name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
team_member
- team_member_id — BIGINT
- team_id — BIGINT — Foreign key → team.team_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- role_name — VARCHAR(50)
- is_leader — BOOLEAN — NOT NULL
- status — VARCHAR(30) — NOT NULL
- joined_at — DATETIME — NOT NULL
team_member_recommendation
- team_member_recommendation_id — BIGINT
- run_id — BIGINT — Foreign key → recommendation_run.run_id — NOT NULL
- recommended_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- recommended_role — VARCHAR(50)
- match_score — DECIMAL(5,2) — NOT NULL
- rank_order — INT — NOT NULL
- reason_1 — VARCHAR(255)
- reason_2 — VARCHAR(255)