firstday

Tables (37)

application_memos

  • application_memo_id — bigint — Primary key — NOT NULL
  • application_id — bigint — Foreign key → applications.application_id — NOT NULL
  • author_user_id — bigint — Foreign key → users.user_id — NOT NULL
  • memo — text — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

application_status_history

  • application_status_id — bigint — Primary key — NOT NULL
  • application_id — bigint — Foreign key → applications.application_id — NOT NULL
  • from_status — varchar(20)
  • to_status — varchar(20) — NOT NULL
  • change_reason — varchar(1000)
  • changed_by — bigint — Foreign key → users.user_id
  • actor_type — varchar(10) — NOT NULL
  • changed_at — datetime(6) — NOT NULL

applications

  • application_id — bigint — Primary key — NOT NULL
  • job_posting_id — bigint — Foreign key → job_postings.job_posting_id — NOT NULL
  • applicant_user_id — bigint — Foreign key → users.user_id — NOT NULL
  • resume_id — bigint — Foreign key → resumes.resume_id — 지원에 사용한 이력서 원본; 원본 삭제 후에는 NULL
  • resume_snapshot_json — json — NOT NULL — 지원 완료 시점의 이력서·지원자 연락처 전체 스냅샷
  • cover_letter_id — bigint — Foreign key → cover_letters.cover_letter_id
  • cover_letter_snapshot_json — json
  • current_status — varchar(20) — NOT NULL
  • applied_at — datetime(6) — NOT NULL
  • cancelled_at — datetime(6) — 지원완료 단계에서 지원자가 취소한 시각
  • termination_reason — varchar(20) — 채용종료 원인; 현재는 기업탈퇴
  • terminated_at — datetime(6) — 지원 절차가 채용종료로 끝난 시각
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • active_application_guard — tinyint

banners

  • banner_id — bigint — Primary key — NOT NULL
  • banner_name — varchar(200) — NOT NULL
  • placement — varchar(30) — NOT NULL
  • image_url — varchar(1000) — NOT NULL
  • link_url — varchar(1000)
  • alt_text — varchar(255) — NOT NULL
  • display_order — int — NOT NULL
  • starts_at — datetime(6)
  • ends_at — datetime(6)
  • is_active — tinyint(1) — NOT NULL
  • created_by — bigint — Foreign key → users.user_id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

companies

  • company_id — bigint — Primary key — NOT NULL
  • business_number — varchar(20) — NOT NULL
  • company_name — varchar(200) — NOT NULL
  • representative_name — varchar(100)
  • established_date — date
  • industry_name — varchar(100)
  • company_size — varchar(50)
  • homepage_url — varchar(1000)
  • logo_url — varchar(1000)
  • postal_code — varchar(20)
  • address_line1 — varchar(255)
  • address_line2 — varchar(255)
  • short_description — varchar(300)
  • introduction — longtext
  • benefits — longtext
  • approval_status — varchar(10) — NOT NULL — 가입 심사: 승인대기/승인/반려
  • company_status — varchar(10) — NOT NULL — 운영 상태: 정상/이용정지/탈퇴
  • latest_rejection_code — varchar(50)
  • latest_rejection_reason — varchar(1000)
  • reviewed_by — bigint — Foreign key → users.user_id
  • reviewed_at — datetime(6)
  • reapply_requested_at — datetime(6)
  • review_requested_at — datetime(6) — 가장 최근 심사 요청 시각; NULL이면 기업정보 작성 중이라 심사 큐에 노출하지 않음
  • row_version — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • withdrawn_at — datetime(6)
  • employee_count — int — 사원수

company_reviews

  • company_review_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → companies.company_id — NOT NULL
  • author_user_id — bigint — Foreign key → users.user_id — NOT NULL
  • eligibility_application_id — bigint — Foreign key → applications.application_id — NOT NULL
  • employment_status — varchar(10) — NOT NULL
  • job_category_id — bigint — Foreign key → job_categories.job_category_id
  • career_growth_rating — tinyint — NOT NULL
  • work_satisfaction_rating — tinyint — NOT NULL
  • compensation_rating — tinyint — NOT NULL
  • culture_rating — tinyint — NOT NULL
  • overall_rating — decimal(2, 1) — NOT NULL
  • pros — text — NOT NULL
  • cons — text — NOT NULL
  • summary — varchar(300) — NOT NULL
  • status — varchar(10) — NOT NULL
  • hidden_reason — varchar(1000)
  • hidden_by — bigint — Foreign key → users.user_id
  • admin_memo — varchar(2000) — 관리자 후기 처리 메모
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • help_count — int — NOT NULL

cover_letter_ai_reviews

  • cover_letter_ai_review_id — bigint — Primary key — NOT NULL
  • cover_letter_id — bigint — Foreign key → cover_letters.cover_letter_id — NOT NULL
  • job_posting_id — bigint — Foreign key → job_postings.job_posting_id — NOT NULL — 첨삭 대상으로 선택한 채용공고
  • original_content — json — NOT NULL — 첨삭 요청 당시 문항·답변 전체 스냅샷
  • revised_content — json — NOT NULL — AI가 제안한 문항별 수정 답변 전체
  • feedback — longtext — 전체 첨삭 요약과 개선 이유
  • rag_context — json — 문항별 RAG 검색 근거 문단; 문항 순서와 같은 순서의 배열
  • created_at — datetime(6) — NOT NULL

cover_letter_items

  • cover_letter_item_id — bigint — Primary key — NOT NULL
  • cover_letter_id — bigint — Foreign key → cover_letters.cover_letter_id — NOT NULL
  • question — varchar(1000) — NOT NULL
  • answer — longtext — NOT NULL
  • display_order — int — NOT NULL
  • updated_at — datetime(6) — NOT NULL

cover_letters

  • cover_letter_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • status — varchar(10) — NOT NULL
  • row_version — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

faq_categories

  • faq_category_id — bigint — Primary key — NOT NULL
  • category_name — varchar(100) — NOT NULL
  • display_order — int — NOT NULL
  • is_active — tinyint(1) — NOT NULL

faqs

  • faq_id — bigint — Primary key — NOT NULL
  • faq_category_id — bigint — Foreign key → faq_categories.faq_category_id — NOT NULL
  • question — varchar(500) — NOT NULL
  • answer — longtext — NOT NULL
  • display_order — int — NOT NULL
  • status — varchar(10) — NOT NULL
  • created_by — bigint — Foreign key → users.user_id — NOT NULL
  • updated_by — bigint — Foreign key → users.user_id — 마지막으로 수정한 관리자; 최초 등록자는 created_by
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

inquiries

  • inquiry_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • inquiry_category_id — bigint — Foreign key → inquiry_categories.inquiry_category_id — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • status — varchar(10) — NOT NULL
  • answer_content — longtext
  • answered_by — bigint — Foreign key → users.user_id
  • answered_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

inquiry_attachments

  • inquiry_attachment_id — bigint — Primary key — NOT NULL
  • inquiry_id — bigint — Foreign key → inquiries.inquiry_id — NOT NULL
  • original_name — varchar(255) — NOT NULL
  • storage_key — varchar(1000) — NOT NULL
  • mime_type — varchar(100) — NOT NULL
  • file_size — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL

inquiry_categories

  • inquiry_category_id — bigint — Primary key — NOT NULL
  • category_name — varchar(100) — NOT NULL
  • display_order — int — NOT NULL
  • is_active — tinyint(1) — NOT NULL

interview_reviews

  • interview_review_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → companies.company_id — NOT NULL
  • author_user_id — bigint — Foreign key → users.user_id — NOT NULL
  • job_posting_id — bigint — Foreign key → job_postings.job_posting_id — NOT NULL
  • application_id — bigint — Foreign key → applications.application_id — NOT NULL
  • interview_month — char(7) — NOT NULL — YYYY-MM
  • interview_type — varchar(30) — NOT NULL
  • interview_result — varchar(10) — NOT NULL
  • difficulty — varchar(10) — NOT NULL
  • process_text — text — NOT NULL
  • content — longtext — NOT NULL
  • tips — text
  • status — varchar(10) — NOT NULL
  • hidden_reason — varchar(1000)
  • hidden_by — bigint — Foreign key → users.user_id
  • admin_memo — varchar(2000) — 관리자 후기 처리 메모
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • help_count — int — NOT NULL

job_categories

  • job_category_id — bigint — Primary key — NOT NULL
  • parent_id — bigint — Foreign key → job_categories.job_category_id
  • category_name — varchar(100) — NOT NULL
  • slug — varchar(120) — NOT NULL
  • depth — tinyint — NOT NULL
  • display_order — int — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

job_posting_skills

  • job_posting_id — bigint — Foreign key → job_postings.job_posting_id — NOT NULL
  • skill_id — bigint — Foreign key → skills.skill_id — NOT NULL

job_postings

  • job_posting_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → companies.company_id — NOT NULL
  • job_category_id — bigint — Foreign key → job_categories.job_category_id
  • title — varchar(255) — NOT NULL
  • employment_type — varchar(20)
  • career_type — varchar(20)
  • min_experience_years — tinyint
  • max_experience_years — tinyint
  • education_level — varchar(30)
  • work_region — varchar(100)
  • work_address — varchar(500)
  • salary_text — varchar(100)
  • salary_min — int — 만원 단위
  • salary_max — int — 만원 단위
  • headcount — smallint
  • apply_start_at — datetime(6)
  • apply_end_at — datetime(6)
  • introduction — longtext
  • main_tasks — longtext
  • qualifications — longtext
  • preferred_conditions — longtext
  • benefits_json — json
  • process_text — text
  • status — varchar(10) — NOT NULL — 임시저장/모집예정/모집중/마감/숨김/재검토요청/삭제
  • close_reason — varchar(20) — 기업마감/마감일도래/기업탈퇴
  • hidden_reason — varchar(1000) — 관리자가 공고를 숨긴 구체적인 사유
  • hidden_by — bigint — Foreign key → users.user_id — 공고 숨김을 처리한 관리자 회원 ID
  • hidden_at — datetime(6) — 공고를 숨김 상태로 변경한 시각
  • view_count — bigint — NOT NULL
  • published_at — datetime(6)
  • closed_at — datetime(6)
  • row_version — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

notices

  • notice_id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — longtext — NOT NULL
  • is_pinned — tinyint(1) — NOT NULL
  • status — varchar(10) — NOT NULL
  • published_at — datetime(6)
  • created_by — bigint — Foreign key → users.user_id — NOT NULL
  • updated_by — bigint — Foreign key → users.user_id — 마지막으로 수정한 관리자; 최초 등록자는 created_by
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

personal_profiles

  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • postal_code — varchar(20)
  • address_line1 — varchar(255)
  • address_line2 — varchar(255)
  • profile_image_url — varchar(1000)
  • row_version — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

policies

  • policy_id — bigint — Primary key — NOT NULL
  • policy_code — varchar(50) — NOT NULL
  • title — varchar(200) — NOT NULL
  • audience — varchar(10) — NOT NULL — 전체/개인/기업
  • consent_type — varchar(10) — NOT NULL — 필수/선택/공개
  • content — longtext — NOT NULL
  • effective_from — datetime(6)
  • display_order — int — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • updated_by — bigint — Foreign key → users.user_id
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

reports

  • report_id — bigint — Primary key — NOT NULL
  • reporter_user_id — bigint — Foreign key → users.user_id — NOT NULL
  • target_type — varchar(20) — NOT NULL
  • target_id — bigint — NOT NULL
  • reason_code — varchar(30) — NOT NULL
  • detail — varchar(2000)
  • status — varchar(10) — NOT NULL
  • resolution_action — varchar(10)
  • resolution_note — varchar(2000)
  • handled_by — bigint — Foreign key → users.user_id
  • created_at — datetime(6) — NOT NULL
  • handled_at — datetime(6)

resume_careers

  • career_id — bigint — Primary key — NOT NULL
  • resume_id — bigint — Foreign key → resumes.resume_id — NOT NULL
  • company_name — varchar(200) — NOT NULL
  • department — varchar(100)
  • position_title — varchar(100)
  • employment_type — varchar(50)
  • start_date — date — NOT NULL
  • end_date — date
  • is_current — tinyint(1) — NOT NULL
  • description — longtext
  • display_order — int — NOT NULL

resume_educations

  • education_id — bigint — Primary key — NOT NULL
  • resume_id — bigint — Foreign key → resumes.resume_id — NOT NULL
  • school_name — varchar(200) — NOT NULL
  • major — varchar(200)
  • degree — varchar(100)
  • admission_date — date
  • graduation_date — date
  • graduation_status — varchar(20)
  • gpa_score — decimal(3,2)
  • gpa_scale — decimal(3,2)
  • display_order — int — NOT NULL

resume_projects

  • project_id — bigint — Primary key — NOT NULL
  • resume_id — bigint — Foreign key → resumes.resume_id — NOT NULL
  • project_name — varchar(200) — NOT NULL
  • role_text — varchar(300)
  • description — longtext
  • start_date — date
  • end_date — date
  • project_url — varchar(1000)
  • display_order — int — NOT NULL

resume_skills

  • resume_id — bigint — Foreign key → resumes.resume_id — NOT NULL
  • skill_id — bigint — Foreign key → skills.skill_id — NOT NULL
  • display_order — tinyint — NOT NULL

resumes

  • resume_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • applicant_name — varchar(100) — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone — varchar(30) — NOT NULL
  • career_type — varchar(20) — NOT NULL
  • summary — text
  • status — varchar(10) — NOT NULL
  • row_version — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

review_reactions

  • review_type — varchar(10) — Primary key — NOT NULL — 기업리뷰/면접후기
  • review_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • created_at — datetime(6) — NOT NULL

salary_records

  • salary_record_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → companies.company_id — NOT NULL
  • author_user_id — bigint — Foreign key → users.user_id — NOT NULL
  • job_category_id — bigint — Foreign key → job_categories.job_category_id — NOT NULL
  • employment_status — varchar(10) — NOT NULL
  • employment_type — varchar(30) — NOT NULL
  • career_years — tinyint — NOT NULL
  • salary_year — smallint — NOT NULL
  • base_salary — int — NOT NULL — 세전 연봉, 만원 단위
  • bonus_amount — int — 성과급, 만원 단위
  • consented_at — datetime(6) — NOT NULL
  • status — varchar(10) — NOT NULL
  • hidden_reason — varchar(1000)
  • hidden_by — bigint — Foreign key → users.user_id
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

saved_companies

  • company_id — bigint — Foreign key → companies.company_id — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • created_at — datetime(6) — NOT NULL

saved_jobs

  • job_posting_id — bigint — Foreign key → job_postings.job_posting_id — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • created_at — datetime(6) — NOT NULL

site_settings

  • setting_key — varchar(100) — Primary key — NOT NULL
  • setting_value — json — NOT NULL
  • updated_by — bigint — Foreign key → users.user_id — NOT NULL
  • updated_at — datetime(6) — NOT NULL

site_versions

  • site_version_id — bigint — Primary key — NOT NULL
  • version_name — varchar(50) — NOT NULL
  • change_notes — longtext — NOT NULL
  • created_by — bigint — Foreign key → users.user_id — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

skills

  • skill_id — bigint — Primary key — NOT NULL
  • parent_id — bigint — Foreign key → skills.skill_id
  • depth — tinyint — NOT NULL
  • skill_name — varchar(100) — NOT NULL
  • slug — varchar(120) — NOT NULL
  • display_order — int — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

user_desired_jobs

  • job_category_id — bigint — Foreign key → job_categories.job_category_id — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • display_order — tinyint — NOT NULL
  • created_at — datetime(6) — NOT NULL

user_policy_consents

  • consent_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • policy_id — bigint — Foreign key → policies.policy_id — NOT NULL
  • consented — tinyint(1) — NOT NULL
  • consented_at — datetime(6) — NOT NULL
  • withdrawn_at — datetime(6)
  • ip_address — varchar(45)
  • user_agent — varchar(500)

users

  • user_id — bigint — Primary key — NOT NULL
  • company_id — bigint — Foreign key → companies.company_id — 기업회원이 소속된 기업; 개인·관리자는 NULL
  • login_id — varchar(50) — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL — 개인회원 이름 또는 기업 담당자 이름
  • email — varchar(255) — NOT NULL — 로그인 계정 이메일; 기업회원은 담당자 이메일
  • phone — varchar(30) — 계정 연락처; 기업회원은 담당자 연락처
  • department — varchar(100) — 기업 담당자 부서; 개인·관리자는 NULL
  • position_title — varchar(100) — 기업 담당자 직급·직책; 개인·관리자는 NULL
  • user_type — varchar(10) — NOT NULL — 개인/기업/관리자
  • account_status — varchar(10) — NOT NULL — 정상/이용정지/탈퇴
  • last_login_at — datetime(6)
  • password_changed_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • withdrawn_at — datetime(6)