w
Tables (9)
activity_log
- log_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(26) — Foreign key → users.user_id — NOT NULL
- action_type — VARCHAR(30) — NOT NULL — VISIT | SIGNUP | LOGIN | DOCUMENT_UPLOAD | AUDIO_UPLOAD | GITHUB_CONNECT | CONVERSATION_START | ITEM_CREATE | RESUME_DR…
- target — VARCHAR(255) — 파일명 · 저장소명
- created_at — DATETIME — NOT NULL
conversation
- conversation_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(26) — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(200)
- transcript — TEXT — Q: / A: 접두로 줄 단위 저장
- audio_document_id — BIGINT — Foreign key → document.document_id — 세션 녹음 파일
- current_step — INT — NOT NULL
- total_steps — INT — NOT NULL
- answered_count — INT — NOT NULL
- is_complete — TINYINT — NOT NULL — false면 이어서 답하기 노출
- created_at — DATETIME — NOT NULL
cv_item
- cv_item_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(26) — Foreign key → users.user_id — NOT NULL
- item_type — VARCHAR(20) — NOT NULL — PROJECT | CERTIFICATE | LANGUAGE | EDUCATION | CAREER | AWARD
- title — VARCHAR(200) — NOT NULL
- category — VARCHAR(50) — 문서 자동화 등
- organization — VARCHAR(200)
- tech_stack — VARCHAR(500)
- start_date — DATE
- end_date — DATE — 정렬 기준 — 자격증은 취득일
- detail — VARCHAR(2000) — 유형별 부가정보 (JSON)
- primary_source — VARCHAR(20) — NOT NULL — DOCUMENT | GITHUB | CONVERSATION | MANUAL
- source_desc — VARCHAR(200) — 목록에 표시되는 출처 문구
- status — VARCHAR(20) — NOT NULL — ANALYZING | PENDING | VERIFIED | REJECTED
- is_included — TINYINT — NOT NULL — 이력서에 실을지 여부
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cv_item_section
- section_id — BIGINT — Primary key — NOT NULL
- cv_item_id — BIGINT — Foreign key → cv_item.cv_item_id — NOT NULL
- section_type — VARCHAR(20) — NOT NULL — ROLE | PROBLEM | SOLUTION | RESULT | SUMMARY
- content — VARCHAR(2000)
- sort_order — INT — NOT NULL
- is_edited — TINYINT — NOT NULL — 사용자가 고친 섹션은 재분석이 덮어쓰지 않는다
- updated_at — DATETIME — NOT NULL
document
- document_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(26) — Foreign key → users.user_id — NOT NULL
- source_type — VARCHAR(20) — NOT NULL — DOCUMENT | AUDIO | TEXT | ETC
- file_name — VARCHAR(255) — NOT NULL
- file_ext — VARCHAR(10) — NOT NULL
- file_size — BIGINT — NOT NULL — 목록의 5.1 MB 표기
- file_path — VARCHAR(500) — NOT NULL
- page_count — INT
- parse_status — VARCHAR(20) — NOT NULL — PENDING | PROCESSING | DONE | FAILED
- fail_reason — VARCHAR(30) — NO_TEXT_LAYER | UNSUPPORTED_FORMAT | FILE_TOO_LARGE | PARSE_ERROR
- uploaded_at — DATETIME — NOT NULL
evidence_mapping
- evidence_id — BIGINT — Primary key — NOT NULL
- section_id — BIGINT — Foreign key → cv_item_section.section_id — NOT NULL
- source_type — VARCHAR(20) — NOT NULL — GITHUB | DOCUMENT | CONVERSATION | MANUAL
- document_id — BIGINT — Foreign key → document.document_id
- repo_id — BIGINT — Foreign key → github_repo.repo_id
- conversation_id — BIGINT — Foreign key → conversation.conversation_id
- source_ref — VARCHAR(255) — README.md 3-9행 / 커밋 해시 / 02:14
- quote — VARCHAR(2000) — 원문 인용
- external_url — VARCHAR(500) — 원본으로 바로 이동
- created_at — DATETIME — NOT NULL
github_repo
- repo_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(26) — Foreign key → users.user_id — NOT NULL
- full_name — VARCHAR(200) — NOT NULL — minjun/market-clone
- description — VARCHAR(500)
- language — VARCHAR(50)
- star_count — INT
- my_commit_count — INT — 내 커밋 수 — 팀 기여도 구분용
- total_commit_count — INT
- has_readme — TINYINT — NOT NULL
- first_commit_at — DATE
- last_commit_at — DATE
- is_selected — TINYINT — NOT NULL — 분석 대상 체크 상태
- fetched_at — DATETIME — NOT NULL
profile
- user_id — VARCHAR(26) — Foreign key → users.user_id — NOT NULL
- birthday — DATE
- phone — VARCHAR(20)
- address — VARCHAR(255)
- github_url — VARCHAR(255)
- blog_url — VARCHAR(255)
- updated_at — DATETIME — NOT NULL
users
- user_id — VARCHAR(26) — Primary key — NOT NULL — 계정 식별자
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — 구글 로그인은 NULL
- provider — VARCHAR(20) — NOT NULL — EMAIL | GOOGLE
- user_name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL — USER | ADMIN
- github_username — VARCHAR(100)
- github_token — VARCHAR(500) — 암호화 저장
- github_synced_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL