Multi-Agent Collaboration for Team and Friends
TypeScript agent-automationagent-orchestrationagent-workflowai-agentsai-collaborationai-memoryai-workforceautonomous-agentsclaude-codeclaude-code-skillscodexcoding-agentmulti-agentmultiple-agentone-person-businessone-person-companyone-person-teamopencodesolopreneur
CREATE TABLE IF NOT EXISTS artifact (
id TEXT PRIMARY KEY,
conversation_id TEXT NOT NULL REFERENCES conversation(id) ON DELETE CASCADE,
agent_id TEXT NOT NULL,
workspace_id TEXT NOT NULL REFERENCES workspace(id) ON DELETE CASCADE,
filename TEXT NOT NULL,
content_type TEXT NOT NULL DEFAULT 'application/octet-stream',
size INTEGER NOT NULL,
r2_key TEXT NOT NULL,
created_at TEXT NOT NULL DEFAULT (datetime('now')),
FOREIGN KEY (agent_id, workspace_id) REFERENCES agent(id, workspace_id) ON DELETE CASCADE
);
CREATE INDEX IF NOT EXISTS idx_artifact_conversation ON artifact(conversation_id);