2

Tables (12)

analysis_report

  • report_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • report_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • error_code — VARCHAR(50)
  • pdf_object_key — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

analysis_report_company

  • report_company_id — BIGINT — Primary key — NOT NULL
  • report_id — BIGINT — Foreign key → analysis_report.report_id — NOT NULL
  • company_code — VARCHAR(20) — Foreign key → company.company_code — NOT NULL
  • position_id — BIGINT — Foreign key → job_position.position_id — NOT NULL
  • rank — INTEGER
  • fit_score — NUMERIC(5,2)

analysis_report_item

  • item_id — BIGINT — Primary key — NOT NULL
  • report_company_id — BIGINT — Foreign key → analysis_report_company.report_company_id — NOT NULL
  • item_type — VARCHAR(30) — NOT NULL
  • content — TEXT — NOT NULL

company

  • company_code — VARCHAR(20) — Primary key — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • industry — VARCHAR(50)
  • people — INTEGER — NOT NULL
  • insight — INTEGER — NOT NULL

company_insight

  • insight_id — BIGINT — Primary key — NOT NULL
  • company_code — VARCHAR(20) — Foreign key → company.company_code — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id
  • category — VARCHAR(20) — NOT NULL
  • position_id — BIGINT — Foreign key → job_position.position_id
  • content — TEXT — NOT NULL
  • content_hash — VARCHAR(64)
  • embedding — VECTOR(1536)
  • created_at — TIMESTAMP — NOT NULL

company_insight_tech

  • insight_id — BIGINT — Foreign key → company_insight.insight_id — NOT NULL
  • tech_id — BIGINT — Foreign key → tech_stack.tech_id — NOT NULL

job_position

  • position_id — BIGINT — Primary key — NOT NULL
  • position_name — VARCHAR(100) — NOT NULL

job_seeker_profile

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • desired_position_id — BIGINT — Foreign key → job_position.position_id

job_seeker_tech

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • tech_id — BIGINT — Foreign key → tech_stack.tech_id — NOT NULL

profile_content

  • content_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • content_hash — VARCHAR(64)
  • embedding — VECTOR(1536)
  • created_at — TIMESTAMP — NOT NULL

tech_stack

  • tech_id — BIGINT — Primary key — NOT NULL
  • tech_name — VARCHAR(50) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL