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