JobFit

Tables (12)

email_verification

  • verification_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • verification_code — VARCHAR(6) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • is_verified — TINYINT(1) — NOT NULL
  • verified_at — DATETIME
  • created_at — DATETIME — NOT NULL

favorite_job

  • favorite_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL
  • created_at — DATETIME — NOT NULL

job_category

  • job_category_id — BIGINT — Primary key — NOT NULL
  • source_site — VARCHAR(30) — NOT NULL
  • source_category_code — VARCHAR(50) — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL
  • normalized_name — VARCHAR(100) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

job_posting

  • job_id — BIGINT — Primary key — NOT NULL
  • source_site — VARCHAR(30) — NOT NULL
  • source_job_id — VARCHAR(100) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • job_title — VARCHAR(255) — NOT NULL
  • career_type — VARCHAR(30)
  • region — VARCHAR(100)
  • employment_type — VARCHAR(50)
  • education — VARCHAR(100)
  • salary — VARCHAR(100)
  • work_schedule — VARCHAR(255)
  • description — LONGTEXT
  • requirements — LONGTEXT
  • preferred_qualifications — LONGTEXT
  • raw_keywords — JSON
  • posted_at — DATE
  • deadline — DATE
  • original_url — VARCHAR(500) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • crawled_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

job_posting_category

  • job_posting_category_id — BIGINT — Primary key — NOT NULL
  • job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL
  • job_category_id — BIGINT — Foreign key → job_category.job_category_id — NOT NULL
  • created_at — DATETIME — NOT NULL

job_skill

  • job_skill_id — BIGINT — Primary key — NOT NULL
  • job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
  • occurrence_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

matching_analysis

  • analysis_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • selected_skill_count — INT — NOT NULL
  • recommended_job_count — INT — NOT NULL
  • average_match_score — DECIMAL(5,2) — NOT NULL
  • highest_match_score — DECIMAL(5,2) — NOT NULL
  • analyzed_at — DATETIME — NOT NULL

matching_history

  • history_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • job_id — BIGINT — Foreign key → job_posting.job_id — NOT NULL
  • match_score — DECIMAL(5,2) — NOT NULL
  • matched_skill_count — INT — NOT NULL
  • missing_skill_count — INT — NOT NULL
  • analyzed_at — DATETIME — NOT NULL

skill

  • skill_id — BIGINT — Primary key — NOT NULL
  • source_site — VARCHAR(30) — NOT NULL
  • source_skill_code — VARCHAR(50) — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • normalized_name — VARCHAR(100) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

skill_alias

  • skill_alias_id — BIGINT — Primary key — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
  • alias_name — VARCHAR(100) — NOT NULL
  • normalized_alias — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

user_profile

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 로그인 이메일
  • user_name — VARCHAR(100) — NOT NULL — 사용자 이름
  • password_hash — VARCHAR(255) — NOT NULL — 암호화된 비밀번호
  • desired_region — VARCHAR(100)
  • career_years — INT — NOT NULL
  • agree_marketing — TINYINT(1) — NOT NULL — 맞춤 채용정보 이메일 수신 동의
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_skill

  • user_skill_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_profile.user_id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
  • proficiency_level — VARCHAR(20)
  • created_at — DATETIME — NOT NULL