erDiagram
  ASSISTANTMODEL {
    string name
    string display_name
    string family
    number size
    string modified_at
    number power_rank
    boolean web_search_capable
    boolean vision_capable
    string provider
    boolean available
  }
  ASSISTANTMODELSRESPONSE {
    boolean ok
    boolean ollama_available
    string models
    string error
    string providers
  }
  ASSISTANTCHATREQUEST {
    string question
    string model
    string mode
    boolean use_web
    boolean include_sources
    string language
  }
  ASSISTANTVISIONREQUEST {
    string question
    string model
    string image_base64
    string mime_type
    boolean include_sources
    string language
  }
  ASSISTANTCITATION {
    string type
    string source_id
    string title
    number page
    string url
    string snippet
  }
  ASSISTANTANSWERSECTION {
    string heading
    string items
  }
  ASSISTANTANSWER {
    string title
    string summary
    string sections
    string confidence
    string grounding_status
    boolean needs_review
  }
  ASSISTANTCHATRESPONSE {
    string answer
    string citations
    string web_citations
    string model
    boolean used_web
    string warnings
    string provider
  }
  LOCALCONTEXTSNIPPET {
    string record_id
    string record_type
    string title
    string source_file
    number page
    string snippet
    number confidence
  }
  WEBSEARCHRESULT {
    string title
    string url
    string snippet
    string provider
    string retrieved_at
  }
  PROVIDERHEALTH {
    string name
    string provider_type
    boolean healthy
    boolean enabled
    string default_model
    string capabilities
    string error
  }
  PROVIDERMETADATA {
    string primary
    string used
    boolean fallback_used
    string fallback_reason
    string model
    number latency_ms
    string circuit_state
    number context_snippets
    number web_context_snippets
  }
  AUDITLOGRECORD {
    string id
    string actor_user_id
    string actor_tenant_id
    string target_type
    string target_id
    string action
    string before_json
    string after_json
    string ip_address
    string user_agent
  }
  USERPUBLIC {
    string id
    string email
    string phone
    string full_name
    string status
    boolean is_super_admin
    string last_login_at
    string created_at
    string updated_at
  }