agentstudio

Tables (89)

AGENT_STUDIO_ERROR_LOG

  • ERROR_ID — VARCHAR(100) — Primary key — NOT NULL
  • SERVER_GROUP — NUMERIC(38, 0) — NOT NULL
  • SERVER_ID — NUMERIC(38, 0) — NOT NULL
  • SERVER_IP — VARCHAR(100) — NOT NULL
  • SERVER_NAME — VARCHAR(100) — NOT NULL
  • REPORTED_TIME — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • ERROR_MESSAGE — TEXT
  • SERVICE_STACK — TEXT
  • RAW_STACK — TEXT

account_integrates

  • id — UUID — Primary key — NOT NULL
  • account_id — UUID — NOT NULL
  • provider — VARCHAR(16) — NOT NULL
  • open_id — VARCHAR(255) — NOT NULL
  • encrypted_token — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

accounts

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • password_salt — VARCHAR(255)
  • avatar — VARCHAR(255)
  • interface_language — VARCHAR(255)
  • interface_theme — VARCHAR(255)
  • timezone — VARCHAR(255)
  • last_login_at — TIMESTAMP WITHOUT TIME ZONE
  • last_login_ip — VARCHAR(255)
  • last_active_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • initialized_at — TIMESTAMP WITHOUT TIME ZONE
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

agent_conversation_summaries

  • id — UUID — Primary key — NOT NULL
  • conversation_id — UUID — Foreign key → agent_conversations.id — NOT NULL
  • summary_scope — VARCHAR(20) — NOT NULL
  • turn_start — INTEGER
  • turn_end — INTEGER
  • summary_text — TEXT — NOT NULL
  • summarized_turn_count — INTEGER — NOT NULL
  • last_summarized_message_id — UUID
  • token_count — INTEGER
  • summary_status — VARCHAR(20) — NOT NULL
  • heartbeat_at — TIMESTAMP WITHOUT TIME ZONE
  • error_message — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

agent_conversations

  • id — UUID — Primary key — NOT NULL
  • agent_id — UUID — Foreign key → single_agent.id
  • app_id — UUID — Foreign key → apps.id
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • web_search_enabled — BOOLEAN — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • last_message — TEXT — NOT NULL
  • last_message_at — TIMESTAMP WITHOUT TIME ZONE
  • message_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP WITHOUT TIME ZONE
  • deleted_by — UUID
  • delete_reason — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

agent_favorites

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • agent_type — VARCHAR(40) — NOT NULL
  • agent_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

agent_messages

  • id — UUID — Primary key — NOT NULL
  • conversation_id — UUID — Foreign key → agent_conversations.id — NOT NULL
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • error — TEXT
  • parent_message_id — UUID — Foreign key → agent_messages.id
  • turn_id — UUID — NOT NULL
  • prompt_tokens — INTEGER — NOT NULL
  • completion_tokens — INTEGER — NOT NULL
  • total_tokens — INTEGER — NOT NULL
  • tool_events_json — TEXT
  • metadata — JSON — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

agent_run_events

  • id — UUID — Primary key — NOT NULL
  • run_id — UUID — Foreign key → agent_runs.id — NOT NULL
  • conversation_id — UUID — Foreign key → agent_conversations.id — NOT NULL
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • event_type — VARCHAR(64) — NOT NULL
  • sequence — INTEGER — NOT NULL
  • payload — JSON — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

agent_runs

  • id — UUID — Primary key — NOT NULL
  • conversation_id — UUID — Foreign key → agent_conversations.id — NOT NULL
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • turn_id — UUID — NOT NULL
  • input_message_id — UUID — Foreign key → agent_messages.id
  • status — VARCHAR(32) — NOT NULL
  • error — TEXT
  • prompt_tokens — INTEGER — NOT NULL
  • completion_tokens — INTEGER — NOT NULL
  • total_tokens — INTEGER — NOT NULL
  • metadata — JSON — NOT NULL
  • started_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • completed_at — TIMESTAMP WITHOUT TIME ZONE
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

api_requests

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • api_token_id — UUID — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • request — TEXT
  • response — TEXT
  • ip — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

api_tokens

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID
  • tenant_id — UUID
  • type — VARCHAR(16) — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • last_used_at — TIMESTAMP WITHOUT TIME ZONE
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

app_annotation_hit_histories

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • annotation_id — UUID — NOT NULL
  • source — TEXT — NOT NULL
  • question — TEXT — NOT NULL
  • account_id — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • score — FLOAT — NOT NULL
  • message_id — UUID — NOT NULL
  • annotation_question — TEXT — NOT NULL
  • annotation_content — TEXT — NOT NULL

app_annotation_settings

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • score_threshold — FLOAT — NOT NULL
  • collection_binding_id — UUID — NOT NULL
  • created_user_id — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_user_id — UUID — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

app_mcp_servers

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • server_code — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • parameters — TEXT — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

app_model_configs

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • provider — VARCHAR(255)
  • model_id — VARCHAR(255)
  • configs — JSON
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • opening_statement — TEXT
  • suggested_questions — TEXT
  • suggested_questions_after_answer — TEXT
  • speech_to_text — TEXT
  • text_to_speech — TEXT
  • more_like_this — TEXT
  • model — TEXT
  • user_input_form — TEXT
  • dataset_query_variable — VARCHAR(255)
  • pre_prompt — TEXT
  • agent_mode — TEXT
  • sensitive_word_avoidance — TEXT
  • retriever_resource — TEXT
  • prompt_type — VARCHAR(255) — NOT NULL
  • chat_prompt_config — TEXT
  • completion_prompt_config — TEXT
  • dataset_configs — TEXT
  • file_upload — TEXT

app_triggers

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID — NOT NULL
  • node_id — VARCHAR(64) — NOT NULL
  • trigger_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • provider_name — VARCHAR(255)
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

apps

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • mode — VARCHAR(255) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • icon_type — VARCHAR(255)
  • icon — VARCHAR(255)
  • icon_background — VARCHAR(255)
  • app_model_config_id — UUID
  • workflow_id — UUID
  • status — VARCHAR(255) — NOT NULL
  • enable_site — BOOLEAN — NOT NULL
  • enable_api — BOOLEAN — NOT NULL
  • api_rpm — INTEGER — NOT NULL
  • api_rph — INTEGER — NOT NULL
  • is_demo — BOOLEAN — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • is_universal — BOOLEAN — NOT NULL
  • tracing — TEXT
  • owner_id — UUID
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • max_active_requests — INTEGER
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • use_icon_as_answer_icon — BOOLEAN — NOT NULL

celery_taskmeta

  • id — INTEGER — Primary key — NOT NULL
  • task_id — VARCHAR(155) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • result — BYTEA
  • date_done — TIMESTAMP WITHOUT TIME ZONE
  • traceback — TEXT
  • name — VARCHAR(155)
  • args — BYTEA
  • kwargs — BYTEA
  • worker — VARCHAR(155)
  • retries — INTEGER
  • queue — VARCHAR(155)

celery_tasksetmeta

  • id — INTEGER — Primary key — NOT NULL
  • taskset_id — VARCHAR(155) — NOT NULL
  • result — BYTEA
  • date_done — TIMESTAMP WITHOUT TIME ZONE

chat_prompt_snapshots

  • id — UUID — Primary key — NOT NULL
  • conversation_id — UUID — NOT NULL
  • user_message_id — UUID — NOT NULL
  • model_id — VARCHAR(255)
  • prompt_payload_json — TEXT — NOT NULL
  • tool_description_payload_json — TEXT — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

chat_prompts

  • id — VARCHAR(64) — Primary key — NOT NULL
  • DEFAULT_SYSTEM_PROMPT — TEXT
  • DOCUMENT_ANSWER_SYSTEM_PROMPT — TEXT
  • WEB_SEARCH_SYSTEM_PROMPT — TEXT
  • QUERY_RESTRUCTURE_PROMPT_TEMPLATE — TEXT
  • QUERY_EXPANSION_PROMPT_TEMPLATE — TEXT
  • TOOL_SELECTION_SYSTEM_PROMPT — TEXT
  • SERVER_SELECTION_SYSTEM_PROMPT — TEXT
  • CHILD_TOOL_LOOP_SYSTEM_PROMPT — TEXT
  • DOCUMENT_HINT — TEXT
  • TITLE_SUMMARIZE_PROMPT — TEXT
  • DOCUMENT_SCOPE_SELECTION_PROMPT — TEXT
  • DOCUMENT_SUMMARIZE_PROMPT — TEXT
  • SUMMARIZER_SYSTEM_PROMPT — TEXT
  • MAP_PROMPT_TEMPLATE — TEXT
  • REDUCE_PROMPT_TEMPLATE — TEXT
  • TOOL_DESC_GET_FULL_DOCUMENT — TEXT
  • TOOL_DESC_KNOWLEDGE_SEARCH — TEXT
  • TOOL_DESC_SEARCH_PAGES — TEXT
  • TOOL_DESC_SUMMARIZER — TEXT
  • CONVERSATION_SUMMARY_SYSTEM_PROMPT — TEXT
  • CONVERSATION_SUMMARY_INITIAL_TEMPLATE — TEXT
  • CONVERSATION_SUMMARY_INCREMENTAL_TEMPLATE — TEXT
  • SERVER_DESC_KNOWLEDGE — TEXT
  • ACTIVITY_MESSAGES — TEXT
  • TOOL_GROUNDED_ANSWER_GUIDE — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

cli_sessions

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • owner_user_id — UUID — NOT NULL
  • name — VARCHAR(255)
  • description — VARCHAR(1024)
  • status — VARCHAR(32) — NOT NULL
  • image — VARCHAR(512) — NOT NULL
  • container_id — VARCHAR(128)
  • container_name — VARCHAR(128)
  • ssh_host — VARCHAR(255)
  • ssh_port — INTEGER — NOT NULL
  • ssh_private_key_encrypted — TEXT
  • ssh_public_key — TEXT
  • mem_limit — VARCHAR(32)
  • cpus — FLOAT
  • pids_limit — INTEGER
  • last_activity_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • expires_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • terminated_at — TIMESTAMP WITHOUT TIME ZONE
  • terminated_reason — VARCHAR(255)
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

code_agent

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • icon — VARCHAR(255) — NOT NULL
  • icon_bg — VARCHAR(255) — NOT NULL
  • instruction — TEXT — NOT NULL
  • llm_provider — VARCHAR(255) — NOT NULL
  • llm_model — VARCHAR(255) — NOT NULL
  • llm_params — TEXT — NOT NULL
  • tool_server_ids — TEXT — NOT NULL
  • workflow_tool_ids — TEXT — NOT NULL
  • workflow_tool_versions — TEXT — NOT NULL
  • memory — TEXT — NOT NULL
  • code_tools_enabled — BOOLEAN — NOT NULL
  • enabled_builtin_tools — TEXT — NOT NULL
  • max_iterations — INTEGER — NOT NULL
  • enable_api — BOOLEAN — NOT NULL
  • published_version_id — UUID
  • tenant_id — UUID
  • owner_id — UUID
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

code_agent_execution_logs

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • code_agent_id — UUID — NOT NULL
  • version_id — UUID
  • version — VARCHAR(255) — NOT NULL
  • agent_name — VARCHAR(255) — NOT NULL
  • triggered_from — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • inputs — TEXT
  • outputs — TEXT
  • error — TEXT
  • prompt_tokens — BIGINT — NOT NULL
  • completion_tokens — BIGINT — NOT NULL
  • total_tokens — BIGINT — NOT NULL
  • elapsed_time — FLOAT — NOT NULL
  • created_by — UUID
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • started_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • finished_at — TIMESTAMP WITHOUT TIME ZONE
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

code_agent_versions

  • id — UUID — Primary key — NOT NULL
  • code_agent_id — UUID — Foreign key → code_agent.id — NOT NULL
  • tenant_id — UUID — NOT NULL
  • version — VARCHAR(255) — NOT NULL
  • marked_name — VARCHAR(255) — NOT NULL
  • marked_comment — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • icon — VARCHAR(255) — NOT NULL
  • icon_bg — VARCHAR(255) — NOT NULL
  • instruction — TEXT — NOT NULL
  • llm_provider — VARCHAR(255) — NOT NULL
  • llm_model — VARCHAR(255) — NOT NULL
  • llm_params — TEXT — NOT NULL
  • tool_server_ids — TEXT — NOT NULL
  • workflow_tool_ids — TEXT — NOT NULL
  • workflow_tool_versions — TEXT — NOT NULL
  • code_tools_enabled — BOOLEAN — NOT NULL
  • enabled_builtin_tools — TEXT — NOT NULL
  • max_iterations — INTEGER — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

conversations

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • app_model_config_id — UUID
  • model_provider — VARCHAR(255)
  • override_model_configs — TEXT
  • model_id — VARCHAR(255)
  • mode — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • summary — TEXT
  • inputs — JSON — NOT NULL
  • introduction — TEXT
  • system_instruction — TEXT
  • system_instruction_tokens — INTEGER — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • invoke_from — VARCHAR(255)
  • from_source — VARCHAR(255) — NOT NULL
  • from_end_user_id — UUID
  • from_account_id — UUID
  • read_at — TIMESTAMP WITHOUT TIME ZONE
  • read_account_id — UUID
  • dialogue_count — INTEGER — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

dify_setups

  • version — VARCHAR(255) — Primary key — NOT NULL
  • setup_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

end_users

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID
  • type — VARCHAR(255) — NOT NULL
  • external_user_id — VARCHAR(255)
  • name — VARCHAR(255)
  • is_anonymous — BOOLEAN — NOT NULL
  • session_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

evaluation_case_results

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • run_id — UUID — NOT NULL
  • row_index — INTEGER — NOT NULL
  • actual_value — TEXT — NOT NULL
  • is_correct — BOOLEAN
  • score — FLOAT
  • reason — TEXT
  • metrics_json — TEXT
  • error — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

evaluation_datasets

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_key — VARCHAR(512) — NOT NULL
  • columns_json — TEXT — NOT NULL
  • row_count — INTEGER — NOT NULL
  • mapping_json — TEXT — NOT NULL
  • validation_status — VARCHAR(32) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

evaluation_runs

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • dataset_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • target_type — VARCHAR(64) — NOT NULL
  • target_id — VARCHAR(255) — NOT NULL
  • scoring_type — VARCHAR(32) — NOT NULL
  • evaluator_agent_id — VARCHAR(255)
  • input_mappings_json — TEXT — NOT NULL
  • execution_scope — VARCHAR(32) — NOT NULL
  • run_limit — INTEGER
  • status — VARCHAR(32) — NOT NULL
  • total_count — INTEGER — NOT NULL
  • correct_count — INTEGER — NOT NULL
  • incorrect_count — INTEGER — NOT NULL
  • accuracy — FLOAT — NOT NULL
  • error — TEXT
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • started_at — TIMESTAMP WITHOUT TIME ZONE
  • completed_at — TIMESTAMP WITHOUT TIME ZONE
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

installed_apps

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID — NOT NULL
  • app_owner_tenant_id — UUID — NOT NULL
  • position — INTEGER — NOT NULL
  • is_pinned — BOOLEAN — NOT NULL
  • last_used_at — TIMESTAMP WITHOUT TIME ZONE
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

invitation_codes

  • id — SERIAL — Primary key — NOT NULL
  • batch — VARCHAR(255) — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • used_at — TIMESTAMP WITHOUT TIME ZONE
  • used_by_tenant_id — UUID
  • used_by_account_id — UUID
  • deprecated_at — TIMESTAMP WITHOUT TIME ZONE
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

knowledge_bases

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • index_name — VARCHAR(255)
  • index_status — VARCHAR(32) — NOT NULL
  • index_error — TEXT
  • gateway_url — VARCHAR(1024)
  • gateway_api_key_encrypted — TEXT
  • gateway_timeout — FLOAT — NOT NULL
  • gateway_postgres_dsn_encrypted — TEXT
  • gateway_postgres_connect_timeout — INTEGER — NOT NULL
  • gateway_status — VARCHAR(32) — NOT NULL
  • gateway_error — TEXT
  • gateway_checked_at — TIMESTAMP WITHOUT TIME ZONE
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • deleted_at — TIMESTAMP WITHOUT TIME ZONE

knowledge_documents

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • knowledge_base_id — UUID — Foreign key → knowledge_bases.id — NOT NULL
  • upload_file_id — UUID — Foreign key → upload_files.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • extension — VARCHAR(64) — NOT NULL
  • mime_type — VARCHAR(255)
  • size — BIGINT — NOT NULL
  • index_name — VARCHAR(255)
  • external_document_id — VARCHAR(255)
  • page_count — INTEGER — NOT NULL
  • chunk_count — INTEGER — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • error — TEXT
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • deleted_at — TIMESTAMP WITHOUT TIME ZONE

knowledge_file_indexes

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • scope_type — VARCHAR(64) — NOT NULL
  • scope_id — VARCHAR(255) — NOT NULL
  • upload_file_id — UUID — Foreign key → upload_files.id — NOT NULL
  • index_name — VARCHAR(255) — NOT NULL
  • external_document_id — VARCHAR(255)
  • status — VARCHAR(32) — NOT NULL
  • error — TEXT
  • page_count — INTEGER — NOT NULL
  • chunk_count — INTEGER — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

mcp_tool_metadata_overrides

  • id — UUID — Primary key — NOT NULL
  • tool_id — UUID — Foreign key → node_config.id — NOT NULL
  • mcp_tool_name — VARCHAR(150) — NOT NULL
  • description — TEXT
  • input_schema_json — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

mcp_tool_user_selections

  • id — UUID — Primary key — NOT NULL
  • tool_id — UUID — Foreign key → node_config.id — NOT NULL
  • user_id — UUID — Foreign key → accounts.id — NOT NULL
  • selection_mode — VARCHAR(32) — NOT NULL
  • enabled_tool_names_json — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

message_agent_thoughts

  • id — UUID — Primary key — NOT NULL
  • message_id — UUID — NOT NULL
  • message_chain_id — UUID
  • position — INTEGER — NOT NULL
  • thought — TEXT
  • tool — TEXT
  • tool_labels_str — TEXT — NOT NULL
  • tool_meta_str — TEXT — NOT NULL
  • tool_input — TEXT
  • observation — TEXT
  • tool_process_data — TEXT
  • message — TEXT
  • message_token — INTEGER
  • message_unit_price — NUMERIC
  • message_price_unit — NUMERIC(10, 7) — NOT NULL
  • message_files — TEXT
  • answer — TEXT
  • answer_token — INTEGER
  • answer_unit_price — NUMERIC
  • answer_price_unit — NUMERIC(10, 7) — NOT NULL
  • tokens — INTEGER
  • total_price — NUMERIC
  • currency — VARCHAR(255)
  • latency — FLOAT
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

message_annotations

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • conversation_id — UUID
  • message_id — UUID
  • question — TEXT
  • content — TEXT — NOT NULL
  • hit_count — INTEGER — NOT NULL
  • account_id — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

message_chains

  • id — UUID — Primary key — NOT NULL
  • message_id — UUID — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • input — TEXT
  • output — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

message_feedbacks

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • conversation_id — UUID — NOT NULL
  • message_id — UUID — NOT NULL
  • rating — VARCHAR(255) — NOT NULL
  • content — TEXT
  • from_source — VARCHAR(255) — NOT NULL
  • from_end_user_id — UUID
  • from_account_id — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

message_files

  • id — UUID — Primary key — NOT NULL
  • message_id — UUID — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • transfer_method — VARCHAR(255) — NOT NULL
  • url — TEXT
  • belongs_to — VARCHAR(255)
  • upload_file_id — UUID
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

messages

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • model_provider — VARCHAR(255)
  • model_id — VARCHAR(255)
  • override_model_configs — TEXT
  • conversation_id — UUID — NOT NULL
  • inputs — JSON — NOT NULL
  • query — TEXT — NOT NULL
  • message — JSON — NOT NULL
  • message_tokens — INTEGER — NOT NULL
  • message_unit_price — NUMERIC(10, 4) — NOT NULL
  • message_price_unit — NUMERIC(10, 7) — NOT NULL
  • answer — TEXT — NOT NULL
  • answer_tokens — INTEGER — NOT NULL
  • answer_unit_price — NUMERIC(10, 4) — NOT NULL
  • answer_price_unit — NUMERIC(10, 7) — NOT NULL
  • parent_message_id — UUID
  • provider_response_latency — FLOAT — NOT NULL
  • total_price — NUMERIC(10, 7)
  • currency — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • error — TEXT
  • message_metadata — TEXT
  • invoke_from — VARCHAR(255)
  • from_source — VARCHAR(255) — NOT NULL
  • from_end_user_id — UUID
  • from_account_id — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • agent_based — BOOLEAN — NOT NULL
  • workflow_run_id — UUID
  • app_mode — VARCHAR(255)

node_config

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • icon — VARCHAR(255) — NOT NULL
  • icon_bg — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • node_group — VARCHAR(255) — NOT NULL
  • depth — INTEGER — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • node_json — TEXT — NOT NULL
  • config_json — TEXT — NOT NULL
  • tenant_id — UUID
  • owner_id — UUID
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • health_status — VARCHAR(16) — NOT NULL
  • health_checked_at — TIMESTAMP WITHOUT TIME ZONE
  • health_latency_ms — INTEGER
  • health_error — VARCHAR(500)

oauth_provider_apps

  • id — UUID — Primary key — NOT NULL
  • app_icon — VARCHAR(255) — NOT NULL
  • app_label — JSON — NOT NULL
  • client_id — VARCHAR(255) — NOT NULL
  • client_secret — VARCHAR(255) — NOT NULL
  • redirect_uris — JSON — NOT NULL
  • scope — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

operation_logs

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • account_id — UUID — NOT NULL
  • action — VARCHAR(255) — NOT NULL
  • content — JSON
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • created_ip — VARCHAR(255) — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

pinned_conversations

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • conversation_id — UUID — NOT NULL
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

prompt_versions

  • id — UUID — Primary key — NOT NULL
  • prompt_id — UUID — Foreign key → prompts.id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • version_name — VARCHAR(128) — NOT NULL
  • version_description — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • variables — JSONB — NOT NULL
  • format — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • deployed_by — UUID — Foreign key → accounts.id
  • deployed_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

prompts

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — Foreign key → tenants.id — NOT NULL
  • created_by — UUID — Foreign key → accounts.id — NOT NULL
  • slug — VARCHAR(128) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • owner_id — UUID
  • updated_by — UUID
  • description — TEXT — NOT NULL
  • category — VARCHAR(128)
  • content — TEXT — NOT NULL
  • variables — JSONB — NOT NULL
  • format — VARCHAR(32) — NOT NULL
  • is_example — BOOLEAN — NOT NULL
  • is_readonly — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • published_version_id — UUID — Foreign key → prompt_versions.id
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • deleted_at — TIMESTAMP WITHOUT TIME ZONE

recommended_apps

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • description — JSON — NOT NULL
  • copyright — VARCHAR(255) — NOT NULL
  • privacy_policy — VARCHAR(255) — NOT NULL
  • custom_disclaimer — TEXT — NOT NULL
  • category — VARCHAR(255) — NOT NULL
  • position — INTEGER — NOT NULL
  • is_listed — BOOLEAN — NOT NULL
  • install_count — INTEGER — NOT NULL
  • language — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

resource_permission_group_members

  • id — UUID — Primary key — NOT NULL
  • group_id — UUID — NOT NULL
  • account_id — UUID — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

resource_permission_groups

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

resource_share_propagations

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • parent_share_id — UUID — NOT NULL
  • parent_resource_type — VARCHAR(32) — NOT NULL
  • parent_resource_id — UUID — NOT NULL
  • resource_type — VARCHAR(32) — NOT NULL
  • resource_id — UUID — NOT NULL
  • shared_with_type — VARCHAR(16) — NOT NULL
  • shared_with_id — UUID — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

resource_shares

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • resource_type — VARCHAR(32) — NOT NULL
  • resource_id — UUID — NOT NULL
  • shared_with_type — VARCHAR(16) — NOT NULL
  • shared_with_id — UUID — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • propagate_children — BOOLEAN — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

saved_messages

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • message_id — UUID — NOT NULL
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

single_agent

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • icon — VARCHAR(255) — NOT NULL
  • icon_bg — VARCHAR(255) — NOT NULL
  • instruction — TEXT — NOT NULL
  • gateway_url — VARCHAR(1024) — NOT NULL
  • llm_provider — VARCHAR(255) — NOT NULL
  • llm_model — VARCHAR(255) — NOT NULL
  • llm_params — TEXT — NOT NULL
  • max_iterations — INTEGER — NOT NULL
  • enable_api — BOOLEAN — NOT NULL
  • published_version_id — UUID
  • tenant_id — UUID
  • owner_id — UUID
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

single_agent_resources

  • id — UUID — Primary key — NOT NULL
  • single_agent_id — UUID — Foreign key → single_agent.id — NOT NULL
  • tenant_id — UUID — NOT NULL
  • resource_type — VARCHAR(64) — NOT NULL
  • resource_id — UUID — NOT NULL
  • metadata — JSON — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

single_agent_versions

  • id — UUID — Primary key — NOT NULL
  • single_agent_id — UUID — Foreign key → single_agent.id — NOT NULL
  • tenant_id — UUID — NOT NULL
  • version — VARCHAR(255) — NOT NULL
  • marked_name — VARCHAR(255) — NOT NULL
  • marked_comment — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • icon — VARCHAR(255) — NOT NULL
  • icon_bg — VARCHAR(255) — NOT NULL
  • instruction — TEXT — NOT NULL
  • gateway_url — VARCHAR(1024) — NOT NULL
  • llm_provider — VARCHAR(255) — NOT NULL
  • llm_model — VARCHAR(255) — NOT NULL
  • llm_params — TEXT — NOT NULL
  • tool_server_ids — TEXT — NOT NULL
  • knowledge_ids — TEXT — NOT NULL
  • max_iterations — INTEGER — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

sites

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • icon_type — VARCHAR(255)
  • icon — VARCHAR(255)
  • icon_background — VARCHAR(255)
  • description — TEXT
  • default_language — VARCHAR(255) — NOT NULL
  • chat_color_theme — VARCHAR(255)
  • chat_color_theme_inverted — BOOLEAN — NOT NULL
  • copyright — VARCHAR(255)
  • privacy_policy — VARCHAR(255)
  • show_workflow_steps — BOOLEAN — NOT NULL
  • use_icon_as_answer_icon — BOOLEAN — NOT NULL
  • custom_disclaimer — TEXT — NOT NULL
  • customize_domain — VARCHAR(255)
  • customize_token_strategy — VARCHAR(255) — NOT NULL
  • prompt_public — BOOLEAN — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • code — VARCHAR(255)

skill_files

  • id — UUID — Primary key — NOT NULL
  • skill_id — UUID — Foreign key → skills.id — NOT NULL
  • path — VARCHAR(1024) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • parent_id — UUID — Foreign key → skill_files.id
  • is_dir — BOOLEAN — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • content_type — VARCHAR(64)
  • storage_key — VARCHAR(512)
  • checksum_sha256 — VARCHAR(64)
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

skills

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — Foreign key → tenants.id — NOT NULL
  • created_by — UUID — Foreign key → accounts.id — NOT NULL
  • slug — VARCHAR(128) — NOT NULL
  • display_name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • icon — VARCHAR(255)
  • icon_bg — VARCHAR(64)
  • is_enabled — BOOLEAN — NOT NULL
  • bundle_storage_key — VARCHAR(512)
  • owner_id — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • deleted_at — TIMESTAMP WITHOUT TIME ZONE

system_settings

  • value — TEXT — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

tenant_account_joins

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • account_id — UUID — NOT NULL
  • current — BOOLEAN — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • invited_by — UUID
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

tenants

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • encrypt_public_key — TEXT
  • plan — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • custom_config — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

terms

  • id — UUID — Primary key — NOT NULL
  • type — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • version — VARCHAR(32)
  • effective_date — DATE
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

tool_conversation_variables

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • tenant_id — UUID — NOT NULL
  • conversation_id — UUID — NOT NULL
  • variables_str — TEXT — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

tool_favorites

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • tool_type — VARCHAR(40) — NOT NULL
  • tool_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

tool_files

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • tenant_id — UUID — NOT NULL
  • conversation_id — UUID
  • file_key — VARCHAR(255) — NOT NULL
  • mimetype — VARCHAR(255) — NOT NULL
  • original_url — VARCHAR(2048)
  • name — VARCHAR(255) — NOT NULL
  • size — INTEGER — NOT NULL

tool_label_bindings

  • id — UUID — Primary key — NOT NULL
  • tool_id — VARCHAR(64) — NOT NULL
  • tool_type — VARCHAR(40) — NOT NULL
  • label_name — VARCHAR(40) — NOT NULL

tool_mcp_providers

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(40) — NOT NULL
  • server_identifier — VARCHAR(64) — NOT NULL
  • server_url — TEXT — NOT NULL
  • server_url_hash — VARCHAR(64) — NOT NULL
  • icon — VARCHAR(255)
  • tenant_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • encrypted_credentials — TEXT
  • authed — BOOLEAN — NOT NULL
  • tools — TEXT — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • timeout — FLOAT — NOT NULL
  • sse_read_timeout — FLOAT — NOT NULL
  • encrypted_headers — TEXT

tool_model_invokes

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • tenant_id — UUID — NOT NULL
  • provider — VARCHAR(255) — NOT NULL
  • tool_type — VARCHAR(40) — NOT NULL
  • tool_name — VARCHAR(128) — NOT NULL
  • model_parameters — TEXT — NOT NULL
  • prompt_messages — TEXT — NOT NULL
  • model_response — TEXT — NOT NULL
  • prompt_tokens — INTEGER — NOT NULL
  • answer_tokens — INTEGER — NOT NULL
  • answer_unit_price — NUMERIC(10, 4) — NOT NULL
  • answer_price_unit — NUMERIC(10, 7) — NOT NULL
  • provider_response_latency — FLOAT — NOT NULL
  • total_price — NUMERIC(10, 7)
  • currency — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

tool_workflow_providers

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • icon — VARCHAR(255) — NOT NULL
  • app_id — UUID — NOT NULL
  • version — VARCHAR(255) — NOT NULL
  • user_id — UUID — NOT NULL
  • tenant_id — UUID — NOT NULL
  • description — TEXT — NOT NULL
  • parameter_configuration — TEXT — NOT NULL
  • privacy_policy — VARCHAR(255)
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

trace_app_config

  • id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • tracing_provider — VARCHAR(255)
  • tracing_config — JSON
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • is_active — BOOLEAN — NOT NULL

upload_files

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • storage_type — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • size — INTEGER — NOT NULL
  • extension — VARCHAR(255) — NOT NULL
  • mime_type — VARCHAR(255)
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • used — BOOLEAN — NOT NULL
  • used_by — UUID
  • used_at — TIMESTAMP WITHOUT TIME ZONE
  • hash — VARCHAR(255)
  • source_url — TEXT — NOT NULL

workflow_agent_triggers

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID — NOT NULL
  • workflow_id — UUID — NOT NULL
  • owner_user_id — UUID — NOT NULL
  • trigger_type — VARCHAR(50) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • terminated_reason — VARCHAR(255)
  • input_mapping — JSON — NOT NULL
  • static_inputs — JSON — NOT NULL
  • webhook_public_id — VARCHAR(24)
  • webhook_method — VARCHAR(16)
  • webhook_auth_type — VARCHAR(32)
  • webhook_secret — TEXT
  • cron_expression — VARCHAR(255)
  • timezone — VARCHAR(64)
  • next_run_at — TIMESTAMP WITHOUT TIME ZONE
  • ends_at — TIMESTAMP WITHOUT TIME ZONE
  • last_run_at — TIMESTAMP WITHOUT TIME ZONE
  • last_success_at — TIMESTAMP WITHOUT TIME ZONE
  • last_failure_at — TIMESTAMP WITHOUT TIME ZONE
  • latest_error — TEXT
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

workflow_app_logs

  • id — UUID — Primary key — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID — NOT NULL
  • workflow_id — UUID — NOT NULL
  • workflow_run_id — UUID — NOT NULL
  • created_from — VARCHAR(255) — NOT NULL
  • created_by_role — VARCHAR(255) — NOT NULL
  • created_by — UUID — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

workflow_conversation_variables

  • id — UUID — Primary key — NOT NULL
  • conversation_id — UUID — Primary key — NOT NULL
  • app_id — UUID — NOT NULL
  • data — TEXT — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL

workflow_draft_variable_files

  • id — UUID — Primary key — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • tenant_id — UUID — NOT NULL
  • app_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • upload_file_id — UUID — NOT NULL
  • size — BIGINT — NOT NULL
  • length — INTEGER
  • value_type — VARCHAR(20) — NOT NULL

workflow_draft_variables

  • id — UUID — Primary key — NOT NULL
  • created_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • updated_at — TIMESTAMP WITHOUT TIME ZONE — NOT NULL
  • app_id — UUID — NOT NULL
  • last_edited_at — TIMESTAMP WITHOUT TIME ZONE
  • node_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • selector — VARCHAR(255) — NOT NULL
  • value_type — VARCHAR(20) — NOT NULL
  • value — TEXT — NOT NULL
  • visible — BOOLEAN — NOT NULL
  • editable — BOOLEAN — NOT NULL
  • node_execution_id — UUID
  • file_id — UUID
  • is_default_value — BOOLEAN — NOT NULL

and 9 more tables