1-- Add parent_conversation_id column for subagent conversations
2ALTER TABLE conversations ADD COLUMN parent_conversation_id TEXT REFERENCES conversations(conversation_id);
3
4-- Index for efficient parent-child lookups
5CREATE INDEX idx_conversations_parent_id ON conversations(parent_conversation_id) WHERE parent_conversation_id IS NOT NULL;