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