dejavu

Tables (9)

ai_recommendations (Untitled)

  • AI피드백ID (ai_recommendation_id) — int — Primary key — NOT NULL
  • 종합피드백 (feedback_text) — text
  • 부족키워드 (response_payload) — json
  • 사용모델명 (model_name) — varchar
  • 생성일시 (created_at) — timestamp
  • 이력서ID (resume_id) — int — Foreign key → resumes.이력서ID — NOT NULL
  • 회원ID (user_id) — int — Foreign key → users.회원ID — NOT NULL
  • 공고ID (job_notice_id) — int — Foreign key → job_notices.공고ID — NOT NULL

bookmarks

  • 북마크ID (bookmark_id) — int — Primary key — NOT NULL
  • 생성일시 (created_at) — timestamp
  • 회원ID (user_id) — int — Foreign key → users.회원ID — NOT NULL
  • 공고ID (job_notice_id) — int — Foreign key → job_notices.공고ID — NOT NULL

job_notice_skills (skills)

  • 기술스택ID (skill_id) — int — Foreign key → skills.기술스택ID — NOT NULL
  • 공고ID (job_notice_id) — int — Foreign key → job_notices.공고ID — NOT NULL
  • 생성일시 (created_at) — timestamp
  • Field

job_notices

  • 공고ID (job_notice_id) — int — Primary key — NOT NULL
  • 공고원본ID (external_notice_id) — varchar
  • 기업명 (company_name) — varchar
  • 공고제목 (title) — varchar
  • 사람인원문URL (source_url) — varchar
  • 대표직무 (job_category) — varchar
  • 근무지 (location_text) — varchar
  • 경력 (experience_level) — varchar
  • 근무 (employment_type) — varchar
  • 학력조건 (education_level) — varchar
  • 급여정보 (salary_text) — varchar
  • 마감일시 (deadline_at) — timestamp
  • 직무/기술키워드 (role_keywords_text) — text
  • 공고원문 (description_raw) — text
  • ai업무예측결과 (ai_analysis_json) — json
  • 사람인응답캐시 (raw_payload) — json
  • 마지막수집시각 (fetched_at) — timestamp
  • 서비스노출여부 (is_active) — boolean
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp
  • Field

resume_project

  • 프로젝트ID (resume_project_id) — int — Primary key — NOT NULL
  • 이력서ID (resume_id) — int — Foreign key → resumes.이력서ID — NOT NULL
  • 프로젝트명 (project_name) — varchar
  • 담당역할 (role_name) — varchar
  • 시작연월 (start_year_month) — char
  • 종료연월 (end_year_month) — char
  • 프로젝트설명 (description) — text
  • 트러블슈팅/성과 (troubleshooting) — text
  • 프로젝트기술스택배열json (tech_stacks_json) — json
  • 출력순서 (sort_order) — int
  • 생성일시 (created_at) — timestamp

resumes

  • 이력서ID (resume_id) — int — Primary key — NOT NULL
  • 이력서제목 (title) — varchar
  • 이름 (name) — varchar
  • 이메일 (email) — varchar
  • 연락처 (phone) — varchar
  • GitHub주소 (github_url) — varchar
  • 블로그주소 (blog_url) — varchar
  • 자기소개 (summary_text) — text
  • 학력배열 (education_json) — json
  • 경력배열 (experience_json) — json
  • 기술스택배열 (resume_skill_names_json) — json
  • 지원동기 (motivation_text) — text
  • 장단점 (strengths_and_weaknesses_text) — text
  • 기본이력서여부 (is_default) — boolean
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp
  • 회원ID (user_id) — int — Foreign key → users.회원ID — NOT NULL

skills (job_notice_skills)

  • 기술스택ID (skill_id) — int — Primary key — NOT NULL
  • 기술스택명 (skill_name) — varchar
  • 카테고리 (category) — varchar
  • 생성일시 (created_at) — timestamp

user_refresh_tokens

  • 리프레시토큰ID (refresh_token_id) — int — Primary key — NOT NULL
  • 리프레시토큰해시 (token_hash) — varchar
  • 만료일시 (expires_at) — timestamp
  • 폐기일시 (revoked_at) — timestamp
  • 발급일시 (created_at) — timestamp
  • 회원ID (user_id) — int — Foreign key → users.회원ID — NOT NULL

users

  • 회원ID (user_id) — int — Primary key — NOT NULL
  • 이메일 (email) — varchar
  • 비밀번호 (password_hash) — varchar
  • 회원상태 (status) — varchar
  • 희망직무 (desired_job_role) — varchar
  • 경력상태 (career_status) — varchar
  • 경력연차 (career_years) — int
  • 기술스택 (preferred_skill_names_json) — json
  • 생성일시 (created_at) — timestamp
  • 수정일시 (updated_at) — timestamp