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