ㄴㄴ

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