s
Tables (9)
claim_calculations
- id — SERIAL
- record_id — INTEGER — NOT NULL
- policy_id — INTEGER — NOT NULL
- calculated_amount — NUMERIC — NOT NULL
- breakdown — JSONB — NOT NULL
- calculated_at — TIMESTAMP
diagnostic_records
- id — SERIAL
- document_id — INTEGER — NOT NULL
- diagnosis_code — VARCHAR(20)
- treatment_start_date — DATE
- treatment_end_date — DATE
- inpatient_days — INTEGER
- outpatient_days — INTEGER
- created_at — TIMESTAMP
insurers
- id — SERIAL
- name — VARCHAR(100) — NOT NULL
policies
- id — SERIAL
- insurer_id — INTEGER — NOT NULL
- name — VARCHAR(200) — NOT NULL
- version — VARCHAR(50)
- created_at — TIMESTAMP
policy_rules
- id — SERIAL
- policy_id — INTEGER — NOT NULL
- category — VARCHAR(50) — NOT NULL
- per_unit — NUMERIC — NOT NULL
- max_total — NUMERIC — NOT NULL
- updated_at — TIMESTAMP
receipt_records
- id — SERIAL
- document_id — INTEGER — NOT NULL
- vendor_name — VARCHAR(200)
- receipt_date — DATE
- total_amount — NUMERIC
- items — JSONB
- created_at — TIMESTAMP
uploaded_documents
- id — SERIAL
- user_id — INTEGER — NOT NULL
- type — VARCHAR(20) — NOT NULL
- file_path — VARCHAR(300) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- uploaded_at — TIMESTAMP
user_policies
- id — SERIAL
- user_id — INTEGER — NOT NULL
- policy_id — INTEGER — NOT NULL
- joined_at — TIMESTAMP
- UNIQUE(user_id, — policy_id)
users
- id — SERIAL
- name — VARCHAR(100)
- email — VARCHAR(150)
- created_at — TIMESTAMP