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