devcompass

Tables (6)

ats_board

  • board_id — INT — Primary key — NOT NULL
  • company_name — VARCHAR(255)
  • ats_source — VARCHAR(255)
  • board_slug — VARCHAR(255)
  • is_enabled — BOOLEAN

daily_skill_demand

  • date — DATE — Primary key — NOT NULL
  • skill_id — INT — Foreign key → skill.skill_id — NOT NULL
  • active_job_count — INT
  • new_job_count — INT
  • closed_job_count — INT

job_posting

  • job_id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → ats_board.board_id
  • source_job_id — VARCHAR(255)
  • title — VARCHAR(255)
  • location — VARCHAR(255)
  • first_seen_at — DATE
  • last_seen_at — DATE
  • is_active — BOOLEAN

job_posting_history

  • history_id — INT — Primary key — NOT NULL
  • job_id — INT — Foreign key → job_posting.job_id
  • content_hash — VARCHAR(255)
  • valid_from — DATE
  • valid_to — DATE

job_skill

  • job_id — INT — Foreign key → job_posting.job_id — NOT NULL
  • skill_id — INT — Foreign key → skill.skill_id — NOT NULL
  • extraction_method — VARCHAR(255)
  • evidence — TEXT

skill

  • skill_id — INT — Primary key — NOT NULL
  • skill_name — VARCHAR(255)
  • canonical_name — VARCHAR(255)
  • category — VARCHAR(255)