homelawyer3.0-2
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
- 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
- purged_at — TIMESTAMPTZ
- 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
- lawyer_id — BIGINT — Foreign key → hl_lawyer_slots.lawyer_id — NOT NULL
- purpose — VARCHAR(20) — NOT NULL
- entry_reason — VARCHAR(20) — NOT NULL
- meet_kind — VARCHAR(10) — Foreign key → hl_lawyer_slots.meet_kind — NOT NULL
- slot_at — TIMESTAMPTZ — Foreign key → hl_lawyer_slots.slot_at — NOT NULL
- duration_min — SMALLINT — Foreign key → hl_lawyer_slots.duration_min — 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
- kind — VARCHAR(4) — NOT NULL
- fact_key — VARCHAR(40) — NOT NULL
- value — TEXT
- internal_value — BIGINT
- quote — TEXT
- applied — BOOLEAN — NOT NULL
- source — VARCHAR(8) — NOT NULL
- source_turn_id — BIGINT — Foreign key → hl_interview_turns.id
- purged_at — TIMESTAMPTZ
- 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_no — VARCHAR(20) — NOT NULL
- user_id — BIGINT — NOT NULL
- apartment_id — BIGINT
- lawyer_id — BIGINT
- side — VARCHAR(10) — NOT NULL
- case_nature — VARCHAR(10)
- case_type — VARCHAR(40)
- route — VARCHAR(12)
- status — VARCHAR(24) — NOT NULL
- ruleset_version — VARCHAR(32) — Foreign key → hl_rulesets.version
- interview_channel — VARCHAR(10)
- interview_prompt_version — VARCHAR(32)
- interview_status — VARCHAR(16)
- question_count — SMALLINT — NOT NULL
- interview_started_at — TIMESTAMPTZ
- interview_ended_at — TIMESTAMPTZ
- sla_due_at — TIMESTAMPTZ
- urgent — BOOLEAN — NOT NULL
- has_user_update — 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
- 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_state — VARCHAR(4)
- deadline_at — DATE
- facts — TEXT
- fills — JSONB
- blocked — JSONB
- review_reasons — JSONB
- published_at — TIMESTAMPTZ
- withdrawn_at — TIMESTAMPTZ
- viewed_at — TIMESTAMPTZ
- purged_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
- purged_at — TIMESTAMPTZ
- 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
- decided_by — VARCHAR(8) — NOT NULL
- adjusted_by_admin_id — BIGINT
- adjusted_at — TIMESTAMPTZ
- input_snapshot — JSONB — 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
- 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
- purged_at — TIMESTAMPTZ
- 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
- 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
- status — VARCHAR(12) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
hl_ruleset_entries
- id — BIGSERIAL — Primary key — NOT NULL
- ruleset_id — BIGINT — Foreign key → hl_rulesets.id — NOT NULL
- kind — VARCHAR(24) — NOT NULL
- data — JSONB — NOT NULL
hl_rulesets
- id — BIGSERIAL — Primary key — NOT NULL
- 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