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)