POC AI service
Tables (5)
EVALUATION
- evaluation_id — BIGINT — Primary key
- status — VARCHAR(20) — NOT NULL — PENDING, PROCESSING, COMPLETED, FAILED
- target_type — VARCHAR(20) — NOT NULL — ORIGINAL or FEEDBACK
- score_job_fit — INT
- score_problem_solving — INT
- score_growth_potential — INT
- score_communication — INT
- total_avg_score — FLOAT
- risk_elements — TEXT — JSON format
- qualitative_feedback — TEXT
- error_message — TEXT
- created_at — TIMESTAMP
- resume_id — BIGINT — Foreign key → RESUME.resume_id
- target_feedback_id — BIGINT — Foreign key → FEEDBACK.feedback_id
FEEDBACK
- feedback_id — BIGINT — Primary key
- status — VARCHAR(20) — NOT NULL — PENDING, PROCESSING, COMPLETED, FAILED
- edited_content — TEXT
- improvement_points — TEXT — JSON format
- error_message — TEXT
- created_at — TIMESTAMP
- resume_id (resume_id2) — BIGINT — Foreign key → RESUME.resume_id
RESUME
- resume_id — BIGINT — Primary key
- job_category — VARCHAR(50) — NOT NULL
- question — TEXT — NOT NULL
- original_content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — BIGINT — Foreign key → USER.user_id
USER
- user_id — BIGINT — Primary key
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
VERSION_CONTROL
- version_id — BIGINT — Primary key
- version_number — INT — NOT NULL
- content_snapshot — TEXT — NOT NULL
- change_reason — VARCHAR(50) — APPLY_FEEDBACK, MANUAL_UPDATE
- created_at — TIMESTAMP
- resume_id — BIGINT — Foreign key → RESUME.resume_id