homelawyer3.0-3

Tables (12)

hl_ai_calls

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • turn_id — BIGINT — Foreign key → hl_interview_turns.id
  • call_kind — VARCHAR(8) — NOT NULL
  • model — VARCHAR(80) — NOT NULL
  • prompt_version — VARCHAR(32) — NOT NULL
  • input_hash — CHAR(64) — NOT NULL
  • input_masked — TEXT
  • output_raw — TEXT
  • invalid_reason — VARCHAR(60)
  • retry_of — BIGINT — Foreign key → hl_ai_calls.id
  • latency_ms — INT
  • tokens_in — INT
  • tokens_out — INT
  • created_at — TIMESTAMPTZ — NOT NULL

hl_bookings

  • id — BIGSERIAL — Primary key — NOT NULL
  • uuid — UUID — NOT NULL
  • case_id — BIGINT — Foreign key → hl_quotes.case_id — NOT NULL
  • slot_id — BIGINT — Foreign key → hl_lawyer_slots.id — NOT NULL
  • purpose — VARCHAR(20) — NOT NULL
  • entry_reason — VARCHAR(20) — NOT NULL
  • quote_id — BIGINT — Foreign key → hl_quotes.id
  • status — VARCHAR(16) — NOT NULL
  • hold_expires_at — TIMESTAMPTZ
  • paid_order_id — BIGINT
  • meeting_info — JSONB
  • deducted_order_id — BIGINT
  • cancelled_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

hl_case_facts

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • fact_kind — VARCHAR(4) — NOT NULL
  • fact_key — VARCHAR(40) — NOT NULL
  • internal_value — BIGINT
  • code_value — VARCHAR(24)
  • quote — TEXT
  • applied — BOOLEAN — NOT NULL
  • fact_source — VARCHAR(8) — NOT NULL
  • source_turn_id — BIGINT — Foreign key → hl_interview_turns.id
  • confirmed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

hl_cases

  • id — BIGSERIAL — Primary key — NOT NULL
  • uuid — UUID — NOT NULL
  • case_number — VARCHAR(20) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • apartment_id — BIGINT
  • lawyer_id — BIGINT
  • side — VARCHAR(10) — NOT NULL
  • case_type_group — VARCHAR(10)
  • case_type — VARCHAR(40)
  • interview_type — VARCHAR(10)
  • case_route — VARCHAR(12)
  • status — VARCHAR(24) — NOT NULL
  • ruleset_id — BIGINT — Foreign key → hl_rulesets.id — NOT NULL
  • sla_due_at — TIMESTAMPTZ
  • urgent — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

hl_diagnoses

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • judgement_id — BIGINT — Foreign key → hl_judgements.id
  • diagnosis_version — SMALLINT — NOT NULL
  • origin — VARCHAR(8) — NOT NULL
  • ai_call_id — BIGINT — Foreign key → hl_ai_calls.id
  • lawyer_id — BIGINT
  • template_id — VARCHAR(12)
  • headline_kind — VARCHAR(10) — NOT NULL
  • deadline_at — DATE
  • facts — TEXT
  • fills — JSONB
  • blocked — JSONB
  • review_reasons — JSONB
  • published_at — TIMESTAMPTZ
  • withdrawn_at — TIMESTAMPTZ
  • viewed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

hl_interview_turns

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • channel — VARCHAR(10) — NOT NULL
  • user_text — TEXT
  • safety_event — VARCHAR(12)
  • payload — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

hl_judgements

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • seq — SMALLINT — NOT NULL
  • is_current — BOOLEAN — NOT NULL
  • adjusted_by_admin_id — BIGINT
  • adjusted_at — TIMESTAMPTZ
  • input_snapshot — TEXT — NOT NULL
  • input_hash — CHAR(64) — NOT NULL
  • ruleset_hash — CHAR(64) — NOT NULL
  • engine_version — VARCHAR(32) — NOT NULL
  • engine_const_hash — CHAR(64)
  • grade — CHAR(1) — NOT NULL
  • track — VARCHAR(8) — NOT NULL
  • recommended_route — VARCHAR(10)
  • axes — JSONB
  • items — JSONB
  • docs — JSONB — NOT NULL
  • judged_at — TIMESTAMPTZ — NOT NULL

hl_lawyer_slots

  • id — BIGSERIAL — Primary key — NOT NULL
  • lawyer_id — BIGINT — NOT NULL
  • slot_at — TIMESTAMPTZ — NOT NULL
  • duration_min — SMALLINT — NOT NULL
  • meet_kind — VARCHAR(10) — NOT NULL
  • closed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

hl_notifications

  • id — BIGSERIAL — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • template_key — VARCHAR(24) — NOT NULL
  • notification_round — SMALLINT — NOT NULL
  • channel — VARCHAR(12) — NOT NULL
  • recipient — VARCHAR(120) — NOT NULL
  • recipient_kind — VARCHAR(8) — NOT NULL
  • recipient_id — BIGINT
  • payload — JSONB
  • scheduled_at — TIMESTAMPTZ
  • sent_at — TIMESTAMPTZ
  • status — VARCHAR(10) — NOT NULL
  • fail_reason — VARCHAR(200)
  • trigger_timeline_id — INT
  • created_at — TIMESTAMPTZ — NOT NULL

hl_quotes

  • id — BIGSERIAL — Primary key — NOT NULL
  • uuid — UUID — NOT NULL
  • case_id — BIGINT — Foreign key → hl_cases.id — NOT NULL
  • judgement_id — BIGINT — Foreign key → hl_judgements.id
  • quote_kind — VARCHAR(12) — NOT NULL
  • supply_amount — BIGINT — NOT NULL
  • vat_amount — BIGINT — NOT NULL
  • disbursement — BIGINT — NOT NULL
  • total_amount — BIGINT — NOT NULL
  • items — JSONB — NOT NULL
  • valid_until — TIMESTAMPTZ — NOT NULL
  • cancelled_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

hl_ruleset_entries

  • id — BIGSERIAL — Primary key — NOT NULL
  • ruleset_id — BIGINT — Foreign key → hl_rulesets.id — NOT NULL
  • entry_kind — VARCHAR(24) — NOT NULL
  • entry_key — VARCHAR(120) — NOT NULL
  • data — JSONB — NOT NULL

hl_rulesets

  • id — BIGSERIAL — Primary key — NOT NULL
  • ruleset_version — VARCHAR(32) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • content_hash — CHAR(64)
  • change_log — JSONB
  • published_at — TIMESTAMPTZ
  • published_by_admin_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL