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