ResumeAgent

Tables (18)

assessments

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • evaluated_job_code — VARCHAR(50)
  • experience — TEXT
  • analysis — TEXT
  • score_data — TEXT
  • is_primary — BOOLEAN
  • capability_vector — JSON
  • capability_levels — JSON
  • status — VARCHAR(20)
  • created_at — DATETIME — NOT NULL

capability_roadmap

  • id — BIGINT
  • assessment_id — BIGINT — Foreign key → assessments.id — NOT NULL
  • cap_code — VARCHAR(50) — NOT NULL
  • current_level — VARCHAR(10)
  • target_level — VARCHAR(10)
  • analysis — TEXT
  • specific_feedback — TEXT
  • roadmap — JSON
  • estimated_score_up — INT
  • status — VARCHAR(20)
  • score_before — INT
  • score_after — INT
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

companies

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • industry — VARCHAR(100)
  • memo — TEXT
  • is_primary — BOOLEAN
  • company_size — VARCHAR(20)
  • added_at — DATETIME — NOT NULL

company_job_postings

  • id — BIGINT
  • company_id — BIGINT — Foreign key → companies.id — NOT NULL
  • position — VARCHAR(200)
  • raw_text — TEXT
  • parsed_data — TEXT
  • jd_profile — JSON
  • analyzed_job_code — VARCHAR(50)
  • is_primary — BOOLEAN
  • status — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

competencies

  • id — BIGINT
  • job_id — BIGINT — Foreign key → jobs.id — NOT NULL
  • cap_code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • weight — DECIMAL(4,3) — NOT NULL

depth_answers

  • id — BIGINT
  • assessment_id — BIGINT — Foreign key → assessments.id — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT
  • sequence — INT
  • created_at — DATETIME — NOT NULL

follow_up_questions

  • id — BIGINT
  • parent_question_id — BIGINT — Foreign key → interview_questions.id
  • question_text — TEXT
  • answer — TEXT
  • evaluation — TEXT

interview_data

  • id — BIGINT
  • assessment_id — BIGINT — Foreign key → assessments.id — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • role — TEXT
  • action — TEXT
  • tech — TEXT
  • result — TEXT
  • raw_qna — TEXT
  • capability_result — TEXT
  • completeness_score — DOUBLE
  • created_at — DATETIME — NOT NULL

interview_questions

  • id — BIGINT
  • interview_result_id — BIGINT — Foreign key → interview_results.id
  • question_text — TEXT
  • answer — TEXT
  • evaluation — TEXT

interview_results

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • resume_content — TEXT — NOT NULL
  • total_questions — INT — NOT NULL
  • created_at — DATETIME

job_postings

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id
  • company_name — VARCHAR(255) — NOT NULL
  • position — VARCHAR(255)
  • main_tasks — VARCHAR(2000)
  • requirements — VARCHAR(2000)
  • preferred — VARCHAR(2000)
  • tech_stack — VARCHAR(255)
  • work_place — VARCHAR(255)
  • employment_type — VARCHAR(255)
  • vision — VARCHAR(2000)
  • capability_vector — JSON
  • created_at — DATETIME
  • updated_at — DATETIME

jobs

  • id — BIGINT
  • group_code — VARCHAR(50) — NOT NULL
  • group_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • description — VARCHAR(500)
  • measure_type — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

password_reset_token

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used — BOOLEAN
  • created_at — DATETIME

payments

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • order_id — VARCHAR(255) — NOT NULL
  • payment_key — VARCHAR(255)
  • plan_id — VARCHAR(255) — NOT NULL
  • amount — INT — NOT NULL
  • credits_charged — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • confirmed_at — DATETIME

projects

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • assessment_id — BIGINT — Foreign key → assessments.id
  • name — VARCHAR(255) — NOT NULL
  • tech_stack — VARCHAR(255)
  • situation — TEXT
  • reason — TEXT
  • action — TEXT
  • result — TEXT
  • created_at — DATETIME

resumes

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • assessment_id — BIGINT — Foreign key → assessments.id
  • job_posting_id — BIGINT — Foreign key → job_postings.id
  • title — VARCHAR(255)
  • content — TEXT
  • status — VARCHAR(50) — NOT NULL
  • evaluation — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

stars

  • id — BIGINT
  • assessment_id — BIGINT — Foreign key → assessments.id — NOT NULL
  • item_name — VARCHAR(255) — NOT NULL
  • situation — TEXT
  • task — TEXT
  • action — TEXT
  • result — TEXT
  • quality — TEXT
  • completeness_score — DOUBLE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

users

  • id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • birth_date — VARCHAR(50)
  • provider_id — VARCHAR(255) — NOT NULL
  • job_category — VARCHAR(255)
  • interest_field — VARCHAR(255)
  • is_active — BOOLEAN
  • credits — INT
  • last_login_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • desired_job_text — VARCHAR(200)
  • mapped_job_code — VARCHAR(50)
  • is_temporary_job — BOOLEAN
  • job_match_type — VARCHAR(20)
  • job_match_confidence — DOUBLE
  • job_mapped_at — DATETIME
  • job_change_count — INT
  • last_job_change_date — DATE
  • primary_assessment_id — BIGINT — Foreign key → assessments.id
  • primary_company_id — BIGINT — Foreign key → companies.id