matching

테이블 (17)

HR 표준 역량 정의 (HRStandard)

  • Key (hr_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (competency_type) — DECIMAL(5,2) — NOT NULL
  • Field2 (definition_text) — TEXT — NOT NULL
  • Field (source_ref) — TIMESTAMP
  • Field (created_at) — timestamptz — NOT NULL

구직자 스킬 (UserSkill)

  • Key (skill_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (skill_name) — VARCHAR(100) — NOT NULL
  • Field2 (proficiency) — ENUM('Beginner','Intermediate','Advanced','Expert') — NOT NULL
  • Field3 (created_at) — timestamptz — NOT NULL
  • Key (user_id) — bigSerial — 외래 키 → 유저.Key — NOT NULL

기업 리뷰 (CompanyReview)

  • Key (review_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (review_text) — text — NOT NULL
  • Field2 (source_url) — VARCHAR(255)
  • Field3 (created_at) — timestamptz — NOT NULL
  • Key (company_id) — bigSerial — 외래 키 → 회사.Key — NOT NULL

유저 (users)

  • Key (id) — bigSerial — 기본 키 — NOT NULL
  • Field2 (email) — varchar(50) — NOT NULL
  • Field2 (name) — varchar(20) — NOT NULL
  • Field3 (phone) — varchar(11)
  • Field4 (final_edu) — varchar(20)
  • Field5 (years_ex) — numeric(3,1)
  • Field2 (update_at) — TIMESTAMPTZ — NOT NULL
  • Field (created_at) — TIMESTAMPTZ — NOT NULL
  • Field (password) — Varchar(20) — NOT NULL
  • Field (user_id) — varchar(20) — NOT NULL

인터뷰 로그 (User_Interview_Log)

  • Key (log_id) — bigSerial — 기본 키 — NOT NULL
  • Field2 (session_id) — uuid — NOT NULL
  • Field4 (question_text) — text
  • Field5 (answer_text) — text
  • Field (answer_tokens) — int — NOT NULL
  • Field (keywords) — jsonB
  • Field (sentiment_score) — real
  • Field (coherence_score) — real
  • Field (created_at) — timestamptz — NOT NULL
  • Key (user_id) — bigSerial — 외래 키 → 유저.Key — NOT NULL
  • Key (question_id) — BIGINT AUTO_INCREMENT (PK) — 외래 키 → 질문-역량 매핑.Key — NOT NULL

인터뷰 피드백 (Interview_Feedback (AI/HR 피드백))

  • Key (feedback_id) — bigSerial — 기본 키 — NOT NULL
  • Field (user_id) — BIGINT — NOT NULL
  • Field (job_id) — BIGINT — NOT NULL
  • Field (source) — VARCHAR(30)
  • Field (session_id) — UUID
  • Field (strengths) — JSONB
  • Field (weaknesses) — JSONB
  • Field (notes) — TEXT
  • (created_at) — TIMESTAMPTZ
  • Key (user_id2) — bigSerial — 외래 키 → 유저.Key — NOT NULL
  • Key (job_id2) — bigSerial — 외래 키 → 채용공고.Key — NOT NULL

임베딩 데이터 (EmbeddingData)

  • Key (embed_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (source_type) — ENUM('user_answer','job_posting','review','question') — NOT NULL
  • Field2 (source_id) — BIGINT — NOT NULL
  • Field3 (created_at) — timestamptz — NOT NULL
  • Field (vector_data) — BLOB — NOT NULL
  • Key (job_id) — bigSerial — 외래 키 → 채용공고.Key — NOT NULL
  • Key (review_id) — BIGINT AUTO_INCREMENT (PK) — 외래 키 → 기업 리뷰.Key — NOT NULL
  • Key (question_id) — BIGINT AUTO_INCREMENT (PK) — 외래 키 → 질문-역량 매핑.Key — NOT NULL
  • Key (log_id) — bigSerial — 외래 키 → 인터뷰 로그.Key — NOT NULL
  • Key (hr_id) — BIGINT AUTO_INCREMENT (PK) — 외래 키 → HR 표준 역량 정의.Key — NOT NULL

적합도 결과 (Matching_Scores)

  • Key (match_id) — bigSerial — 기본 키 — NOT NULL
  • Field (user_id) — BIGINT — NOT NULL
  • Field (job_id) — BIGINT — NOT NULL
  • Field (score_overall) — REAL
  • Field (score_trait) — REAL
  • Field (score_nlp) — REAL
  • Field (score_context) — REAL
  • Field (weights) — JSONB
  • (explanation) — JSONB
  • Field (computed_at) — TIMESTAMPTZ
  • Key (user_id2) — bigSerial — 외래 키 → 유저.Key — NOT NULL
  • Key (job_id2) — bigSerial — 외래 키 → 채용공고.Key — NOT NULL

지원서 (User_Resume)

  • Key (log_id) — bigSerial — 기본 키 — NOT NULL
  • Field2 (resume_text) — text
  • Field3 (embedding) — vector — NOT NULL
  • Field (keywords) — JSONB
  • Field2 (updated_at) — TIMESTAMPTZ
  • Field4 (last_parsed_at) — TIMESTAMPTZ
  • Key (user_id) — bigSerial — 외래 키 → 유저.Key — NOT NULL

직무 역량 가중치 (Job_Requirements)

  • Key (req_id) — bigSerial — 기본 키 — NOT NULL
  • Field (competency_code) — VARCHAR(50) — NOT NULL
  • Field (weight) — REAL — NOT NULL
  • Field (notes) — TEXT
  • Key (job_id) — bigSerial — 외래 키 → 채용공고.Key — NOT NULL

직무&성향 검사 (User_Assessments)

  • Key (assessment_id) — bigSerial — 기본 키 — NOT NULL
  • Field2 (RIASEC_json) — jsonB — NOT NULL
  • Field3 (DISC_json) — jsonB — NOT NULL
  • Field4 (norm_method) — varchar(100)
  • Field5 (assessed_at) — TIMESTAMPTZ — NOT NULL
  • Key (user_id) — bigSerial — 외래 키 → 유저.Key — NOT NULL

질문-역량 매핑 (QuestionBank)

  • Key (question_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (competency_type) — VARCHAR(50) — NOT NULL
  • Field2 (question_text) — TEXT — NOT NULL
  • Field3 (created_at) — timestamptz — NOT NULL
  • Field (source_ref) — VARCHAR(255)
  • Key (hr_id) — BIGINT AUTO_INCREMENT (PK) — 외래 키 → HR 표준 역량 정의.Key — NOT NULL

채용공고 (Job_Postings)

  • Key (job_id) — bigSerial — 기본 키 — NOT NULL
  • Field (title) — VARCHAR(200) — NOT NULL
  • Field (department) — VARCHAR(100)
  • Field (description) — text
  • Field (min_edu) — varchar(100)
  • Field (required_certs) — JSONB
  • Field (required_skills) — JSONB
  • Field (job_vector) — vector
  • Field (salary_range) — VARCHAR(100) — NOT NULL
  • Field (employment_type) — VARCHAR(50) — NOT NULL
  • Field (work_mode) — VARCHAR(50)
  • Key (company_id) — bigSerial — 외래 키 → 회사.Key — NOT NULL

최종 채용 결과 (Hiring_Result)

  • Key (application_id) — bigSerial — 기본 키 — NOT NULL
  • Field (user_id) — BIGINT — NOT NULL
  • Field (job_id) — BIGINT — NOT NULL
  • Field (status) — VARCHAR(30)
  • Field (stage) — VARCHAR(50)
  • Field (decision_date) — TIMESTAMPTZ
  • Field (offer_salary) — NUMERIC(12,2)
  • Field (updated_at) — TIMESTAMPTZ
  • (created_at) — TIMESTAMPTZ
  • Key (user_id2) — bigSerial — 외래 키 → 유저.Key — NOT NULL
  • Key (job_id2) — bigSerial — 외래 키 → 채용공고.Key — NOT NULL

추천 로그 (RecommendationLog)

  • Key (rec_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (match_score) — DECIMAL(5,2) — NOT NULL
  • Field2 (reason_text) — TEXT — NOT NULL
  • Field3 (created_at) — timestamptz — NOT NULL
  • Key (user_id) — bigSerial — 외래 키 → 유저.Key — NOT NULL
  • Key (company_id) — bigSerial — 외래 키 → 회사.Key — NOT NULL
  • Key (job_id) — bigSerial — 외래 키 → 채용공고.Key — NOT NULL

피드백 지표 (FeedbackMetric)

  • Key (metric_id) — BIGINT AUTO_INCREMENT (PK) — 기본 키 — NOT NULL
  • Field (competency_type) — VARCHAR(50) — NOT NULL
  • Field2 (score) — INT(0~100) — NOT NULL
  • Field3 (created_at) — timestamptz — NOT NULL
  • Key (feedback_id) — bigSerial — 외래 키 → 인터뷰 피드백.Key — NOT NULL
  • Key (hr_id) — BIGINT AUTO_INCREMENT (PK) — 외래 키 → HR 표준 역량 정의.Key — NOT NULL

회사 (companies)

  • Key (company_id) — bigSerial — 기본 키 — NOT NULL
  • Field (n ame) — VARCHAR(200) — NOT NULL
  • Field (industry) — VARCHAR(200) — NOT NULL
  • Field (location) — VARCHAR(100)
  • Field (culture_json) — JSONB
  • Field (created_at) — timestamptz
  • Field (work_mode) — VARCHAR(50)
  • Field (company_email) — VARCHAR(255) — NOT NULL
  • Field2 (company_password) — VARCHAR(255) — NOT NULL
  • Field3 (contact_person) — VARCHAR(100)
  • Field (contact_phone) — VARCHAR(50)