Career-Hi
Tables (12)
ai_reports
- report_id — INT — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- target_job — VARCHAR(50)
- match_rate — INT
- overall_summary — TEXT
- ai_comment — TEXT — EX
- market_trend — TEXT
- generated_at — TIMESTAMP
- data_as_of — DATE
market_job_postings
- post_id — INT — Primary key
- company_name — VARCHAR(100)
- job_title — VARCHAR(255)
- job_category — VARCHAR(50)
- required_skills — TEXT
- preferred_skills — TEXT
- source_url — VARCHAR(500)
- posted_at — DATE
- crawled_at — TIMESTAMP
market_skill_stats
- stat_id — INT — Primary key
- job_category — VARCHAR(50)
- skill_name — VARCHAR(50)
- demand_count — INT
- stat_date — DATE — NOT NULL
profile_awards
- award_id — INT — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(50)
- title — VARCHAR(100)
- rank — VARCHAR(50)
- date — VARCHAR(10)
profile_career_goals
- goal_id — INT — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(50)
- sub_roles — TEXT
- languages — TEXT
- portfolio_url — VARCHAR(255)
- portfolio_file_url — VARCHAR(255)
profile_certificates
- cert_id — INT — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- type — VARCHAR(20)
- name — VARCHAR(100)
- authority — VARCHAR(100)
- date — VARCHAR(10)
profile_education
- edu_id — INT — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- school_type — ENUM('UNIVERSITY_4', 'UNIVERSITY_2', 'GRADUATE', 'HIGH_SCHOOL')
- school_name — VARCHAR(100)
- major — VARCHAR(100)
- status — ENUM('ATTENDING', 'LEAVE_OF_ABSENCE', 'COMPLETED', 'EXPECTED_GRADUATION', 'GRADUATED')
- minor — VARCHAR(100)
- club — VARCHAR(100)
profile_language_exams
- lang_id — INT — Primary key
- user_id — INT — Foreign key → users.user_id — NOT NULL
- language — VARCHAR(20)
- exam_name — VARCHAR(50)
- score — VARCHAR(20)
- date — VARCHAR(10)
report_comparisons
- comp_id — INT — Primary key
- report_id — INT — Foreign key → ai_reports.report_id — NOT NULL
- domain_type — ENUM('AWARD', 'PORTFOLIO')
- status — ENUM('FAVORABLE', 'UNFAVORABLE')
- message — TEXT
- user_score — INT
- market_average — INT
report_missing_skills
- skill_id — INT — Primary key
- report_id — INT — Foreign key → ai_reports.report_id — NOT NULL
- name — VARCHAR(50)
- type — VARCHAR(20)
- importance — ENUM('HIGH', 'MEDIUM', 'LOW')
- description — TEXT
report_roadmap_steps
- step_id — INT — Primary key
- report_id — INT — Foreign key → ai_reports.report_id — NOT NULL
- step_order — INT
- title — VARCHAR(100)
- content — TEXT
- action_item — TEXT
users
- user_id — INT — Primary key
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20)
- marketing_agreed — BOOLEAN
- created_at — TIMESTAMP