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