ai_chat
Tables (26)
chat_feedback
- id — INTEGER — Primary key — NOT NULL
- chat_message_id — INTEGER — Foreign key → chat_message.id
- is_positive — BOOLEAN
- required_followup — BOOLEAN
- feedback_text — TEXT
- predefined_feedback — VARCHAR
chat_message
- id — INTEGER — Primary key — NOT NULL
- chat_session_id — UUID — Foreign key → chat_session.id — NOT NULL
- parent_message_id — INTEGER — Foreign key → chat_message.id
- latest_child_message_id — INTEGER — Foreign key → chat_message.id
- last_summarized_message_id — INTEGER — Foreign key → chat_message.id
- preferred_response_id — INTEGER — Foreign key → chat_message.id
- model_display_name — VARCHAR
- reasoning_tokens — TEXT
- message — TEXT — NOT NULL
- token_count — INTEGER — NOT NULL
- message_type — VARCHAR — NOT NULL
- files — JSONB
- citations — JSONB
- error — TEXT
- time_sent — TIMESTAMPTZ — NOT NULL
- is_clarification — BOOLEAN — NOT NULL
- processing_duration_seconds — DOUBLE PRECISION
chat_message__search_doc
- chat_message_id — INTEGER — Foreign key → chat_message.id — NOT NULL
- search_doc_id — INTEGER — Foreign key → search_doc.id — NOT NULL
chat_session
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → user.id
- persona_id — INTEGER — Foreign key → persona.id
- description — TEXT
- onyxbot_flow — BOOLEAN — NOT NULL
- deleted — BOOLEAN — NOT NULL
- shared_status — VARCHAR — NOT NULL
- current_alternate_model — VARCHAR
- slack_thread_id — VARCHAR
- project_id — INTEGER
- llm_override — JSONB
- temperature_override — DOUBLE PRECISION
- prompt_override — JSONB
- time_created — TIMESTAMPTZ — NOT NULL
- time_updated — TIMESTAMPTZ — NOT NULL
connector
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- source — VARCHAR — NOT NULL
- input_type — VARCHAR
- connector_specific_config — JSONB — NOT NULL
- indexing_start — TIMESTAMP
- kg_processing_enabled — BOOLEAN — NOT NULL
- kg_coverage_days — INTEGER
- refresh_freq — INTEGER
- prune_freq — INTEGER
- time_created — TIMESTAMPTZ — NOT NULL
- time_updated — TIMESTAMPTZ — NOT NULL
connector_credential_pair
- connector_id — INTEGER — Foreign key → connector.id — NOT NULL
- credential_id — INTEGER — Foreign key → credential.id — NOT NULL
- id — INTEGER — NOT NULL
- name — VARCHAR — NOT NULL
- status — VARCHAR — NOT NULL
- in_repeated_error_state — BOOLEAN — NOT NULL
- deletion_failure_message — VARCHAR
- access_type — VARCHAR — NOT NULL
- auto_sync_options — JSONB
- last_time_perm_sync — TIMESTAMPTZ
- last_time_external_group_sync — TIMESTAMPTZ
- last_successful_index_time — TIMESTAMPTZ
- last_pruned — TIMESTAMPTZ
- last_time_hierarchy_fetch — TIMESTAMPTZ
- total_docs_indexed — INTEGER — NOT NULL
- indexing_trigger — VARCHAR
- processing_mode — VARCHAR — NOT NULL
- creator_id — UUID
credential
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR
- source — VARCHAR — NOT NULL
- credential_json — BYTEA
- user_id — UUID — Foreign key → user.id
- admin_public — BOOLEAN — NOT NULL
- curator_public — BOOLEAN — NOT NULL
- time_created — TIMESTAMPTZ — NOT NULL
- time_updated — TIMESTAMPTZ — NOT NULL
document
- id — VARCHAR — Primary key — NOT NULL
- from_ingestion_api — BOOLEAN
- boost — INTEGER — NOT NULL
- hidden — BOOLEAN — NOT NULL
- semantic_id — VARCHAR — NOT NULL
- link — VARCHAR
- file_id — VARCHAR
- doc_updated_at — TIMESTAMPTZ
- chunk_count — INTEGER
- content_hash — VARCHAR
- last_modified — TIMESTAMPTZ
- last_synced — TIMESTAMPTZ
- primary_owners — TEXT
- secondary_owners — TEXT
- external_user_emails — TEXT
- external_user_group_ids — TEXT
- is_public — BOOLEAN — NOT NULL
- parent_hierarchy_node_id — INTEGER — Foreign key → hierarchy_node.id
- kg_stage — VARCHAR — NOT NULL
- kg_processing_time — TIMESTAMPTZ
- doc_metadata — JSONB
document__tag
- document_id — VARCHAR — Foreign key → document.id — NOT NULL
- tag_id — INTEGER — Foreign key → tag.id — NOT NULL
document_set
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- description — VARCHAR
- user_id — UUID — Foreign key → user.id
- is_up_to_date — BOOLEAN — NOT NULL
- is_public — BOOLEAN — NOT NULL
- time_last_modified_by_user — TIMESTAMPTZ — NOT NULL
document_set__connector_credential_pair
- is_current — BOOLEAN — Primary key — NOT NULL
- document_set_id — INTEGER — Foreign key → document_set.id — NOT NULL
- connector_credential_pair_id — INTEGER — Foreign key → connector_credential_pair.id — NOT NULL
document_set__user
- document_set_id — INTEGER — Foreign key → document_set.id — NOT NULL
- user_id — UUID — Foreign key → user.id — NOT NULL
hierarchy_node
- id — INTEGER — Primary key — NOT NULL
- raw_node_id — VARCHAR — NOT NULL
- display_name — VARCHAR — NOT NULL
- link — VARCHAR
- source — VARCHAR — NOT NULL
- node_type — VARCHAR — NOT NULL
- external_user_emails — TEXT
- external_user_group_ids — TEXT
- is_public — BOOLEAN — NOT NULL
- document_id — VARCHAR — Foreign key → document.id
index_attempt
- id — INTEGER — Primary key — NOT NULL
- connector_credential_pair_id — INTEGER — Foreign key → connector_credential_pair.id — NOT NULL
- from_beginning — BOOLEAN — NOT NULL
- targeted_reindex_job_id — INTEGER
- status — VARCHAR — NOT NULL
- new_docs_indexed — INTEGER
- total_docs_indexed — INTEGER
- docs_removed_from_index — INTEGER
- error_msg — TEXT
- full_exception_trace — TEXT
- search_settings_id — INTEGER
- poll_range_start — TIMESTAMPTZ
- poll_range_end — TIMESTAMPTZ
- checkpoint_pointer — VARCHAR
- celery_task_id — VARCHAR
- cancellation_requested — BOOLEAN — NOT NULL
llm_provider
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR
- provider — VARCHAR — NOT NULL
- api_key — BYTEA
- api_base — VARCHAR
- api_version — VARCHAR
- custom_config — JSONB
- default_model_name — VARCHAR
- deployment_name — VARCHAR
- is_default_provider — BOOLEAN
- is_default_vision_provider — BOOLEAN
- default_vision_model — VARCHAR
- is_public — BOOLEAN — NOT NULL
- is_auto_mode — BOOLEAN — NOT NULL
model_configuration
- id — INTEGER — Primary key — NOT NULL
- llm_provider_id — INTEGER — Foreign key → llm_provider.id — NOT NULL
- name — VARCHAR — NOT NULL
- is_visible — BOOLEAN — NOT NULL
- max_input_tokens — INTEGER
- supports_image_input — BOOLEAN
- display_name — VARCHAR
- custom_display_name — VARCHAR
persona
- id — INTEGER — Primary key — NOT NULL
- user_id — UUID — Foreign key → user.id
- name — VARCHAR — NOT NULL
- description — VARCHAR — NOT NULL
- default_model_configuration_id — INTEGER — Foreign key → model_configuration.id
- starter_messages — JSONB
- search_start_date — TIMESTAMPTZ
- builtin_persona — BOOLEAN — NOT NULL
- is_featured — BOOLEAN — NOT NULL
- is_listed — BOOLEAN — NOT NULL
- display_priority — INTEGER
- deleted — BOOLEAN — NOT NULL
- system_prompt — VARCHAR
- replace_base_system_prompt — BOOLEAN — NOT NULL
- task_prompt — VARCHAR
- datetime_aware — BOOLEAN — NOT NULL
- uploaded_image_id — VARCHAR
- icon_name — VARCHAR
- is_public — BOOLEAN — NOT NULL
persona__document_set
- persona_id — INTEGER — Foreign key → persona.id — NOT NULL
- document_set_id — INTEGER — Foreign key → document_set.id — NOT NULL
persona__tool
- persona_id — INTEGER — Foreign key → persona.id — NOT NULL
- tool_id — INTEGER — Foreign key → tool.id — NOT NULL
persona__user
- persona_id — INTEGER — Foreign key → persona.id — NOT NULL
- user_id — UUID — Foreign key → user.id — NOT NULL
search_doc
- id — INTEGER — Primary key — NOT NULL
- document_id — VARCHAR — NOT NULL
- chunk_ind — INTEGER — NOT NULL
- semantic_id — VARCHAR — NOT NULL
- link — VARCHAR
- blurb — VARCHAR — NOT NULL
- boost — INTEGER — NOT NULL
- source_type — VARCHAR — NOT NULL
- hidden — BOOLEAN — NOT NULL
- doc_metadata — JSONB — NOT NULL
- score — DOUBLE PRECISION — NOT NULL
- match_highlights — TEXT — NOT NULL
- updated_at — TIMESTAMPTZ
- primary_owners — TEXT
- secondary_owners — TEXT
- is_internet — BOOLEAN
- is_relevant — BOOLEAN
- relevance_explanation — VARCHAR
tag
- id — INTEGER — Primary key — NOT NULL
- tag_key — VARCHAR — NOT NULL
- tag_value — VARCHAR — NOT NULL
- source — VARCHAR — NOT NULL
- is_list — BOOLEAN — NOT NULL
tool
- id — INTEGER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- description — TEXT
- in_code_tool_id — VARCHAR
- display_name — VARCHAR
- openapi_schema — JSONB
- mcp_input_schema — JSONB
- custom_headers — JSONB
- user_id — UUID — Foreign key → user.id
- passthrough_auth — BOOLEAN — NOT NULL
- mcp_server_id — INTEGER
- oauth_config_id — INTEGER
- enabled — BOOLEAN — NOT NULL
tool_call
- id — INTEGER — Primary key — NOT NULL
- chat_session_id — UUID — Foreign key → chat_session.id — NOT NULL
- parent_chat_message_id — INTEGER — Foreign key → chat_message.id
- parent_tool_call_id — INTEGER — Foreign key → tool_call.id
- turn_number — INTEGER — NOT NULL
- tab_index — INTEGER — NOT NULL
- tool_id — INTEGER — NOT NULL
- tool_call_id — VARCHAR — NOT NULL
- reasoning_tokens — TEXT
- tool_call_arguments — JSONB — NOT NULL
- tool_call_response — TEXT — NOT NULL
- tool_call_tokens — INTEGER — NOT NULL
- generated_images — JSONB
tool_call__search_doc
- tool_call_id — INTEGER — Foreign key → tool_call.id — NOT NULL
- search_doc_id — INTEGER — Foreign key → search_doc.id — NOT NULL
user
- id — UUID — Primary key — NOT NULL
- email — VARCHAR(320) — NOT NULL
- hashed_password — VARCHAR(1024) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- is_superuser — BOOLEAN — NOT NULL
- is_verified — BOOLEAN — NOT NULL
- role — VARCHAR — NOT NULL
- account_type — VARCHAR — NOT NULL
- temperature_override_enabled — BOOLEAN
- auto_scroll — BOOLEAN
- shortcut_enabled — BOOLEAN — NOT NULL
- theme_preference — VARCHAR
- chat_background — VARCHAR
- default_app_mode — VARCHAR — NOT NULL
- personal_name — VARCHAR
- personal_role — VARCHAR
- use_memories — BOOLEAN — NOT NULL
- enable_memory_tool — BOOLEAN — NOT NULL
- user_preferences — TEXT
- chosen_assistants — JSONB
- visible_assistants — JSONB — NOT NULL
- hidden_assistants — JSONB — NOT NULL
- pinned_assistants — JSONB
- effective_permissions — JSONB — NOT NULL
- oidc_expiry — TIMESTAMPTZ
- default_model — TEXT
- paste_as_tile — BOOLEAN — NOT NULL
- voice_auto_send — BOOLEAN — NOT NULL
- voice_auto_playback — BOOLEAN — NOT NULL
- voice_playback_speed — DOUBLE PRECISION — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL