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