ㅇ
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