sequenceDiagram
  participant TopicModel
  participant DB as DatabaseTx
  participant Messages
  participant MessagePlugins
  participant IdGen as IdGenerator

  TopicModel->>DB: beginTransaction
  TopicModel->>DB: select messages where topicId,userId orderBy createdAt
  DB-->>TopicModel: originalMessages

  TopicModel->>TopicModel: build messageIds from originalMessages
  TopicModel->>DB: select messagePlugins where id in messageIds
  DB-->>TopicModel: originalPlugins

  TopicModel->>TopicModel: build idMap oldMessageId->newMessageId
  loop build toolIdMap
    TopicModel->>IdGen: generate tool id for each tool in message.tools
    IdGen-->>TopicModel: newToolId
    TopicModel->>TopicModel: store toolIdMap oldToolId->newToolId
  end

  loop for each message in originalMessages (in order)
    TopicModel->>TopicModel: newId = idMap[message.id]
    TopicModel->>TopicModel: newParentId = idMap[message.parentId]
    TopicModel->>TopicModel: remap tools using toolIdMap
    TopicModel->>DB: insert into messages (newId,newParentId,topicId,tools,clientId=null)
    DB-->>TopicModel: insertedMessage

    TopicModel->>TopicModel: plugin = find originalPlugins by plugin.id == message.id
    alt plugin exists
      TopicModel->>TopicModel: newToolCallId = toolIdMap[plugin.toolCallId]
      TopicModel->>DB: insert into messagePlugins (id=newId,toolCallId=newToolCallId,clientId=null)
      DB-->>TopicModel: insertedPlugin
    end
  end

  TopicModel->>DB: commitTransaction

erDiagram
  Topic {
    string id
  }

  Message {
    string id
    string topicId
    string userId
    string parentId
    json   tools
    datetime createdAt
  }

  MessagePlugin {
    string id
    string toolCallId
    string clientId
  }

  Topic ||--o{ Message : has_messages
  Message ||--o{ Message : parent_child
  Message ||--o{ MessagePlugin : has_plugins

  Tool {
    string id
  }

  Message }o--o{ Tool : embedded_tools
  MessagePlugin }o--|| Tool : tool_call_references

classDiagram
  class TopicModel {
    +string userId
    +duplicateTopicWithMessagesAndPlugins(tx, topicId)
  }

  class Message {
    +string id
    +string topicId
    +string userId
    +string parentId
    +json tools
    +datetime createdAt
  }

  class MessagePlugin {
    +string id
    +string toolCallId
    +string clientId
  }

  class IdGenerator {
    +string generateMessagesId()
  }

  class Tool {
    +string id
  }

  TopicModel --> Message : duplicates
  TopicModel --> MessagePlugin : duplicates
  TopicModel --> IdGenerator : uses

  Message "1" --> "0..*" Message : parent_child
  Message "1" --> "0..*" MessagePlugin : has_plugins

  Message "1" --> "0..*" Tool : tools_array
  MessagePlugin "1" --> "0..1" Tool : toolCallId_refers_to