homelawyer3.0-5
Tables (12)
hl_ai_calls
- id — SERIAL — Primary key — NOT NULL
- case_id — INT — Foreign key → hl_cases.id — NOT NULL
- turn_id — INT — 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 — INT — Foreign key → hl_ai_calls.id
- latency_ms — INT
- tokens_in — INT
- tokens_out — INT
- created_at — TIMESTAMP — NOT NULL
hl_bookings
- id — SERIAL — Primary key — NOT NULL
- uuid — UUID — NOT NULL
- case_id — INT — Foreign key → hl_cases.id — NOT NULL
- slot_id — INT — Foreign key → hl_lawyer_slots.id — NOT NULL
- purpose — VARCHAR(20) — NOT NULL
- entry_reason — VARCHAR(20) — NOT NULL
- quote_id — INT — Foreign key → hl_quotes.id
- status — VARCHAR(16) — NOT NULL
- hold_expires_at — TIMESTAMP
- paid_order_id — INT
- meeting_info — JSONB
- deducted_order_id — INT
- cancelled_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
hl_case_facts
- id — SERIAL — Primary key — NOT NULL
- case_id — INT — 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 — INT — Foreign key → hl_interview_turns.id
- confirmed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
hl_cases
- id — SERIAL — Primary key — NOT NULL
- uuid — UUID — NOT NULL
- case_number — VARCHAR(20) — NOT NULL
- user_id — INT — NOT NULL
- apartment_id — INT
- lawyer_id — INT
- 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 — INT — Foreign key → hl_rulesets.id — NOT NULL
- sla_due_at — TIMESTAMP
- urgent — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
hl_diagnoses
- id — SERIAL — Primary key — NOT NULL
- case_id — INT — Foreign key → hl_cases.id — NOT NULL
- judgement_id — INT — Foreign key → hl_judgements.id
- seq — SMALLINT — NOT NULL
- origin — VARCHAR(8) — NOT NULL
- ai_call_id — INT — Foreign key → hl_ai_calls.id
- lawyer_id — INT
- template_id — VARCHAR(12)
- headline_kind — VARCHAR(10) — NOT NULL
- deadline_on — DATE
- facts_summary — TEXT
- fills — JSONB
- blocked — JSONB
- review_reasons — JSONB
- published_at — TIMESTAMP
- withdrawn_at — TIMESTAMP
- viewed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
hl_interview_turns
- id — SERIAL — Primary key — NOT NULL
- case_id — INT — 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 — TIMESTAMP — NOT NULL
hl_judgements
- id — SERIAL — Primary key — NOT NULL
- case_id — INT — Foreign key → hl_cases.id — NOT NULL
- seq — SMALLINT — NOT NULL
- is_current — BOOLEAN — NOT NULL
- adjusted_by_admin_id — INT
- adjusted_at — TIMESTAMP
- input_snapshot — TEXT — NOT NULL
- input_hash — CHAR(64) — NOT NULL
- ruleset_id — INT — Foreign key → hl_rulesets.id — 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 — TIMESTAMP — NOT NULL
hl_lawyer_slots
- id — SERIAL — Primary key — NOT NULL
- lawyer_id — INT — NOT NULL
- slot_at — TIMESTAMP — NOT NULL
- slot_end_at — TIMESTAMP — NOT NULL
- meet_kind — VARCHAR(10) — NOT NULL
- closed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
hl_notifications
- id — SERIAL — Primary key — NOT NULL
- case_id — INT — 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 — INT
- payload — JSONB
- scheduled_at — TIMESTAMP
- sent_at — TIMESTAMP
- status — VARCHAR(10) — NOT NULL
- fail_reason — VARCHAR(200)
- trigger_timeline_id — INT
- created_at — TIMESTAMP — NOT NULL
hl_quotes
- id — SERIAL — Primary key — NOT NULL
- uuid — UUID — NOT NULL
- case_id — INT — Foreign key → hl_cases.id — NOT NULL
- judgement_id — INT — 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 — TIMESTAMP — NOT NULL
- cancelled_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
hl_ruleset_entries
- id — SERIAL — Primary key — NOT NULL
- ruleset_id — INT — 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 — SERIAL — Primary key — NOT NULL
- ruleset_version — VARCHAR(32) — NOT NULL
- status — VARCHAR(10) — NOT NULL
- content_hash — CHAR(64)
- change_log — JSONB
- published_at — TIMESTAMP
- published_by_admin_id — INT
- created_at — TIMESTAMP — NOT NULL