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