AI Agent
Tables (19)
agent_context_windows
- id — SERIAL — Primary key — NOT NULL
- public_id — VARCHAR — NOT NULL
- agent_execution_id — INTEGER — Foreign key → agent_executions.id — NOT NULL
- turn_index — INTEGER — NOT NULL
- role — VARCHAR(16) — NOT NULL
- content — TEXT
- token_count — INTEGER
- created_at — TIMESTAMPTZ
agent_executions
- id — SERIAL — Primary key — NOT NULL
- public_id — VARCHAR — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- state — VARCHAR(32) — NOT NULL
- goal — TEXT
- plan_json — JSONB
- reasoning_trace — JSONB
- job_model_id — INTEGER — Foreign key → job_models.id
- analysis_session_id — INTEGER — Foreign key → analysis_sessions.id
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
analysis_sessions
- id — SERIAL — Primary key — NOT NULL
- public_id — VARCHAR — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- phase — TEXT
- current_step_index — INTEGER — NOT NULL
- group_job_id — TEXT
- steps — JSONB — NOT NULL
- analysis_id — TEXT
- form_params — JSONB
- file_refs — JSONB
- error_message — TEXT
- created_at — TIMESTAMPTZ
chat_feedback
- id — SERIAL — Primary key — NOT NULL
- session_id — TEXT — Foreign key → chat_sessions.id
- user_id — INTEGER — Foreign key → users.id
- message_id — TEXT
- verdict — SMALLINT — NOT NULL
- reason — TEXT
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- model — TEXT
- created_at — TIMESTAMP — NOT NULL
chat_sessions
- id — VARCHAR — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- topic — VARCHAR — NOT NULL
- messages — JSONB — NOT NULL
- memory_prompt — TEXT
- stat — JSONB — NOT NULL
- workflow_job_id — VARCHAR
- workflow_selected_path — JSONB
- last_summarize_index — INTEGER — NOT NULL
- last_update — TIMESTAMP — NOT NULL
execution_input_artifacts
- id — SERIAL — Primary key — NOT NULL
- job_model_id — INTEGER — Foreign key → job_models.id — NOT NULL
- storage_file_id — INTEGER — Foreign key → storage_files.id — NOT NULL
- role — VARCHAR(64)
execution_output_artifacts
- id — SERIAL — Primary key — NOT NULL
- job_model_id — INTEGER — Foreign key → job_models.id — NOT NULL
- storage_file_id — INTEGER — Foreign key → storage_files.id — NOT NULL
- role — VARCHAR(64)
job_models
- id — SERIAL — Primary key — NOT NULL
- public_id — VARCHAR — NOT NULL
- user_id — INTEGER — Foreign key → users.id — NOT NULL
- job_name — TEXT — NOT NULL
- model_name — TEXT — NOT NULL
- model_type — TEXT — NOT NULL
- status — TEXT
- params — JSONB
- executor_job_id — TEXT
- executor_type — VARCHAR(10)
- started_at — TIMESTAMP
- finished_at — TIMESTAMP
knowledge_failure_patterns
- id — SERIAL — Primary key — NOT NULL
- pattern_id — VARCHAR(64) — NOT NULL
- model_id — VARCHAR(64) — Foreign key → knowledge_models.model_id
- error_type — VARCHAR(128) — NOT NULL
- error_message — TEXT — NOT NULL
- root_cause — TEXT
- solution — TEXT — NOT NULL
- prevention_tip — TEXT
- embedding — vector
- created_at — TIMESTAMP
knowledge_interpretation_rules
- id — SERIAL — Primary key — NOT NULL
- rule_id — VARCHAR(64) — NOT NULL
- metric_name — VARCHAR(128) — NOT NULL
- task_type — VARCHAR(64) — NOT NULL
- model_id — VARCHAR(64) — Foreign key → knowledge_models.model_id
- conditions — JSONB — NOT NULL
- explanation_template — JSONB
- direction — VARCHAR(32)
- created_at — TIMESTAMP
knowledge_models
- id — SERIAL — Primary key — NOT NULL
- model_id — VARCHAR(64) — NOT NULL
- display_name — VARCHAR(256) — NOT NULL
- category — VARCHAR(64) — NOT NULL
- subcategory — VARCHAR(64)
- status — VARCHAR(32) — NOT NULL
- task_types — VARCHAR
- input_types — VARCHAR
- output_types — VARCHAR
- aliases — VARCHAR
- parameters — JSONB
- score_ranges — JSONB
- when_to_use — TEXT
- created_at — TIMESTAMP
knowledge_parameter_presets
- id — SERIAL — Primary key — NOT NULL
- model_id — VARCHAR(64) — Foreign key → knowledge_models.model_id — NOT NULL
- preset_name — VARCHAR(64) — NOT NULL
- parameters — JSONB
- description — TEXT
knowledge_tool_documents
- id — SERIAL — Primary key — NOT NULL
- model_id — VARCHAR(64) — Foreign key → knowledge_models.model_id — NOT NULL
- doc_type — VARCHAR(32) — NOT NULL
- title — VARCHAR(512) — NOT NULL
- content — TEXT — NOT NULL
- tsv — tsvector
- created_at — TIMESTAMP
knowledge_tool_embeddings
- id — SERIAL — Primary key — NOT NULL
- model_id — VARCHAR(64) — Foreign key → knowledge_models.model_id — NOT NULL
- text_content — TEXT — NOT NULL
- embedding — vector — NOT NULL
- created_at — TIMESTAMP
knowledge_workflows
- id — SERIAL — Primary key — NOT NULL
- workflow_id — VARCHAR(64) — NOT NULL
- display_name — VARCHAR(256) — NOT NULL
- task_type — VARCHAR(64) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- required_inputs — VARCHAR
- supported_input_types — VARCHAR
- final_outputs — VARCHAR
- steps — JSONB
- created_at — TIMESTAMP
mcp_tool_calls
- id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → users.id
- session_id — TEXT
- surface — TEXT — NOT NULL
- tool_name — TEXT — NOT NULL
- args — JSONB
- ok — BOOLEAN — NOT NULL
- error — TEXT
- latency_ms — INTEGER
- created_at — TIMESTAMP — NOT NULL
storage_files
- id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → users.id
- file_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_type — VARCHAR(50)
- category — VARCHAR(50)
- job_id — VARCHAR(100)
users
- id — SERIAL — Primary key — NOT NULL
- email — TEXT — NOT NULL
- name — TEXT
- role — VARCHAR(20)
- mcp_api_key — VARCHAR(64)
- created_at — TIMESTAMPTZ
workflow_steps
- id — SERIAL — Primary key — NOT NULL
- workflow_id — VARCHAR(64) — Foreign key → knowledge_workflows.workflow_id — NOT NULL
- model_id — VARCHAR(64) — Foreign key → knowledge_models.model_id — NOT NULL
- step_index — INTEGER — NOT NULL
- role — TEXT
- input_from — VARCHAR(32)
- output_to — VARCHAR(32)
- parameter_binding — JSONB
- alternatives — VARCHAR