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)