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