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)