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