Insurance For All

Tables (9)

ai_reports

  • id — UUID — Primary key — NOT NULL
  • anon_session_key — VARCHAR(64) — NOT NULL
  • document_id — UUID
  • scope — VARCHAR(16) — NOT NULL
  • access_token — VARCHAR(64) — NOT NULL
  • input_summary — JSONB — NOT NULL
  • body_markdown — TEXT — NOT NULL
  • is_fallback — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ
  • id (id2) — UUID — Foreign key → uploaded_documents.id — NOT NULL

consultation_requests

  • id — UUID — Primary key — NOT NULL
  • consent_agreed — BOOLEAN — NOT NULL
  • consented_at — TIMESTAMPTZ — NOT NULL
  • contact_encrypted — BYTEA — NOT NULL
  • contact_channel — VARCHAR(16) — NOT NULL
  • purpose_note — VARCHAR(500)
  • anon_session_key — VARCHAR(64)
  • created_at — TIMESTAMPTZ — NOT NULL

masked_coverages

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — NOT NULL
  • coverage_json — JSONB — NOT NULL
  • preview_masked — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • id (id2) — UUID — Foreign key → uploaded_documents.id — NOT NULL

public_cache_heads

  • source — VARCHAR(16) — Primary key — NOT NULL
  • active_sync_run_id — UUID — NOT NULL
  • stale — BOOLEAN — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

public_sync_runs

  • id — UUID — Primary key — NOT NULL
  • source — VARCHAR(16) — NOT NULL
  • base_period — VARCHAR(16) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • row_count — INT
  • started_at — TIMESTAMPTZ — NOT NULL
  • finished_at — TIMESTAMPTZ
  • error_message — TEXT
  • source (source2) — VARCHAR(16) — Foreign key → public_cache_heads.source — NOT NULL

stats_auto_contracts

  • id — UUID — Primary key — NOT NULL
  • sync_run_id — UUID — NOT NULL
  • isu_cmpy_ofr_ym — VARCHAR(6) — NOT NULL
  • isu_itms_nm — VARCHAR(32) — NOT NULL
  • mog_clsf_nm — VARCHAR(64)
  • sex_nm — VARCHAR(8) — NOT NULL
  • aggr — VARCHAR(32) — NOT NULL
  • atmb_plor_nm — VARCHAR(16)
  • kncr_nm — VARCHAR(32)
  • join_cnt — BIGINT
  • elps_inpm — NUMERIC(20,0)
  • fetched_at — TIMESTAMPTZ — NOT NULL
  • id (id2) — UUID — Foreign key → public_sync_runs.id — NOT NULL

stats_life_join_status

  • id — UUID — Primary key — NOT NULL
  • sync_run_id — UUID — NOT NULL
  • stts_accml_trgt_yr — VARCHAR(4) — NOT NULL
  • area_nm — VARCHAR(32) — NOT NULL
  • sex_nm — VARCHAR(8) — NOT NULL
  • rchn_aggr — VARCHAR(32) — NOT NULL
  • isu_kind_nm — VARCHAR(32) — NOT NULL
  • join_cnt — BIGINT
  • join_rto — NUMERIC(8,2)
  • fetched_at — TIMESTAMPTZ — NOT NULL
  • id (id2) — UUID — Foreign key → public_sync_runs.id — NOT NULL

stats_medical_rates

  • id — UUID — Primary key — NOT NULL
  • sync_run_id — UUID — NOT NULL
  • bas_dt — DATE — NOT NULL
  • cmpy_cd — VARCHAR(50)
  • cmpy_nm — VARCHAR(200)
  • ptrn — VARCHAR(150)
  • mog — VARCHAR(100)
  • prd_nm — VARCHAR(600)
  • age — INT — NOT NULL
  • ml_ins_rt — NUMERIC(18,2)
  • fml_ins_rt — NUMERIC(18,2)
  • ofr_inst_nm — VARCHAR(200)
  • fetched_at — TIMESTAMPTZ — NOT NULL
  • id (id2) — UUID — Foreign key → public_sync_runs.id — NOT NULL

uploaded_documents

  • id — UUID — Primary key — NOT NULL
  • anon_session_key — VARCHAR(64) — NOT NULL
  • job_id — VARCHAR(64) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • original_filename — VARCHAR(255)
  • byte_size — INT
  • page_count — INT
  • created_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ
  • fail_reason — TEXT