Law404

Tables (16)

a_part_document_analyses

  • conversation_id — TEXT — Primary key — NOT NULL
  • source_type — TEXT — Primary key — NOT NULL
  • document_type — TEXT — Primary key — NOT NULL
  • analysis_version — TEXT — Primary key — NOT NULL
  • source_document_ids — JSONB — NOT NULL
  • result — JSONB — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

a_part_document_comparisons

  • conversation_id — TEXT — Primary key — NOT NULL
  • source_type — TEXT — Primary key — NOT NULL
  • analysis_version — TEXT — Primary key — NOT NULL
  • result — JSONB — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

a_part_document_extractions

  • extraction_version — TEXT — Primary key — NOT NULL
  • document_id — TEXT — Foreign key → a_part_documents.document_id — NOT NULL
  • processing_status — TEXT — NOT NULL
  • extraction_method — TEXT — NOT NULL
  • page_count — INTEGER — NOT NULL
  • successful_page_count — INTEGER — NOT NULL
  • failed_page_count — INTEGER — NOT NULL
  • direct_text_page_count — INTEGER — NOT NULL
  • ocr_page_count — INTEGER — NOT NULL
  • text_character_count — INTEGER — NOT NULL
  • average_ocr_confidence — DOUBLE PRECISION
  • combined_text — TEXT — NOT NULL
  • pages — JSONB — NOT NULL
  • warnings — JSONB — NOT NULL
  • errors — JSONB — NOT NULL
  • started_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

a_part_documents

  • document_id — TEXT — Primary key — NOT NULL
  • conversation_id — TEXT — NOT NULL
  • source_type — TEXT — NOT NULL
  • document_type — TEXT — NOT NULL
  • page_index — INTEGER — NOT NULL
  • original_filename — TEXT — NOT NULL
  • content_type — TEXT — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • sha256 — TEXT — NOT NULL
  • original_bytes — BYTEA — NOT NULL
  • uploaded_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

a_part_rag_documents

  • id — BIGSERIAL — Primary key — NOT NULL
  • dataset_version — TEXT — NOT NULL
  • collection — TEXT — NOT NULL
  • document_id — TEXT — NOT NULL
  • source_id — TEXT
  • source_type — TEXT
  • title — TEXT
  • text — TEXT — NOT NULL
  • metadata — JSONB — NOT NULL
  • embedding — VECTOR(1536) — NOT NULL
  • embedding_model — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

b_part_embeddings

  • id — SERIAL — Primary key — NOT NULL
  • source_type — VARCHAR(50)
  • content — TEXT — NOT NULL
  • metadata — JSONB
  • embedding — VECTOR(1536)

conversations

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • part — VARCHAR(1) — NOT NULL
  • title — TEXT
  • state — JSONB
  • updated_at — TIMESTAMP

d_part_embeddings

  • id — SERIAL — Primary key — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • statute_name — VARCHAR(100)
  • article_no — VARCHAR(20)
  • case_no — VARCHAR(50)
  • reference_articles — TEXT
  • topic_tags — TEXT
  • grade — CHAR(1)
  • source_date — DATE
  • unresolved_ownership — BOOLEAN — NOT NULL
  • content — TEXT — NOT NULL
  • metadata — JSONB
  • embedding — VECTOR(1536)
  • collected_at — TIMESTAMP — NOT NULL

d_reference_links

  • id — SERIAL — Primary key — NOT NULL
  • source_id — INTEGER — Foreign key → d_part_embeddings.id — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • linked_id — INTEGER — Foreign key → d_part_embeddings.id
  • linked_type — VARCHAR(20) — NOT NULL
  • linked_statute_name — VARCHAR(100)
  • match_basis — VARCHAR(20) — NOT NULL

legal_documents_c

  • id — SERIAL — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • embedding — VECTOR(1536)
  • statute_number — VARCHAR(20)
  • statute_branch — VARCHAR(20)
  • statute_title — VARCHAR(255)
  • case_number — VARCHAR(50)
  • case_name — VARCHAR(255)
  • case_date — DATE
  • chunk_type — VARCHAR(50)
  • source_type — VARCHAR(20) — NOT NULL
  • category_tag — INTEGER — NOT NULL
  • court_level — INTEGER
  • case_year — INTEGER
  • ruling_type — VARCHAR(50)
  • appeal_outcome — VARCHAR(50)
  • related_procedures — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

messages

  • id — SERIAL — Primary key — NOT NULL
  • conversation_id — INTEGER — Foreign key → conversations.id — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

procedure_info

  • id — SERIAL — Primary key — NOT NULL
  • procedure_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • fixed_cost_total — INTEGER
  • fixed_cost_breakdown — TEXT
  • variable_cost_formula — TEXT
  • eligibility — TEXT
  • cost_source — VARCHAR(200)
  • cost_caution — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

refresh_tokens

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • token_hash — TEXT — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMP

region_standards

  • id — SERIAL — Primary key — NOT NULL
  • tier_name — VARCHAR(50) — NOT NULL
  • tier_description — TEXT — NOT NULL
  • deposit_threshold — BIGINT — NOT NULL
  • max_priority_payment — BIGINT — NOT NULL
  • caution_note — TEXT
  • legal_basis — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_calendar_connections

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • connection_id — TEXT — NOT NULL
  • connection_name — TEXT
  • google_email — TEXT
  • status — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_connected_at — TIMESTAMP

users

  • id — SERIAL — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password_hash — TEXT — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP