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)