ㅇ

Tables (13)

AGENT

  • agent_id — BIGINT — Primary key — NOT NULL
  • agent_name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(100)
  • description — TEXT

AGENT_EXECUTION

  • execution_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → TASK.task_id — NOT NULL
  • agent_id — BIGINT — Foreign key → AGENT.agent_id — NOT NULL
  • model_id — BIGINT — Foreign key → MODEL_INFO.model_id — NOT NULL
  • input — LONGTEXT
  • output — LONGTEXT
  • status — VARCHAR(50)
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME

AGENT_MODEL

  • agent_model_id — BIGINT — Primary key — NOT NULL
  • agent_id — BIGINT — Foreign key → AGENT.agent_id — NOT NULL
  • model_id — BIGINT — Foreign key → MODEL_INFO.model_id — NOT NULL
  • priority — INT
  • is_active — BOOLEAN
  • created_at — DATETIME — NOT NULL

ARTIFACT

  • artifact_id — BIGINT — Primary key — NOT NULL
  • task_id — BIGINT — Foreign key → TASK.task_id — NOT NULL
  • agent_id — BIGINT — Foreign key → AGENT.agent_id — NOT NULL
  • project_id — BIGINT — Foreign key → PROJECT.project_id — NOT NULL
  • artifact_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • file_path — VARCHAR(500)
  • file_url — VARCHAR(500)
  • version — INT
  • created_at — DATETIME — NOT NULL

KNOWLEDGE_DOCUMENT

  • document_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — LONGTEXT
  • file_path — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

MEMORY

  • memory_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • importance_score — FLOAT
  • created_at — DATETIME — NOT NULL

MODEL_INFO

  • model_id — BIGINT — Primary key — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • model_type — VARCHAR(50)
  • version — VARCHAR(50)
  • parameter_size — VARCHAR(50)
  • fine_tuned — BOOLEAN
  • performance_score — FLOAT

PROJECT

  • project_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • project_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

PROMPT_HISTORY

  • prompt_id — BIGINT — Primary key — NOT NULL
  • agent_id — BIGINT — Foreign key → AGENT.agent_id — NOT NULL
  • model_id — BIGINT — Foreign key → MODEL_INFO.model_id — NOT NULL
  • input — LONGTEXT
  • prompt — LONGTEXT — NOT NULL
  • response — LONGTEXT
  • score — FLOAT
  • created_at — DATETIME — NOT NULL

REFLECTION_REPORT

  • report_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → PROJECT.project_id — NOT NULL
  • summary — TEXT
  • evaluation — TEXT
  • improvement — TEXT
  • created_at — DATETIME — NOT NULL

TASK

  • task_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → PROJECT.project_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • priority — VARCHAR(20)
  • status — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

USER

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

VECTOR_MEMORY

  • vector_id — BIGINT — Primary key — NOT NULL
  • document_id — BIGINT — Foreign key → KNOWLEDGE_DOCUMENT.document_id — NOT NULL
  • embedding — JSON — NOT NULL
  • metadata — JSON