"""SQLite persistence layer: companies table, jobs table, dedup, company cache, CSV export. Scaffold stub -- not implemented yet. """ # TODO (Stage 4): implement per CLAUDE.md "Stage 4 — Persist & export" and "Data model". # Schema: # companies(company_key PK, name, website, career_url, first_seen) # jobs(job_id PK, company_key, linkedin_url, position_url, status, listed_at, first_seen) # CSV export writes output/results.csv with columns: company_name, career_page_url, open_position_url # (complete rows — status==position_found — sorted first; incomplete rows follow).