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