Sequence: Database Transaction

Multi-step database transaction with rollback handling.

sequence-database-transaction.mmd
sequenceDiagram
  participant C as Client
  participant S as Server
  participant DB as Database
  C->>S: POST /transfer
  S->>DB: BEGIN
  S->>DB: Debit account A
  alt Success
    S->>DB: Credit account B
    S->>DB: INSERT audit_log
    S->>DB: COMMIT
    S-->>C: 200 OK
  else Insufficient funds
    S->>DB: ROLLBACK
    S-->>C: 400 Bad Request
  end
Output
Sequence diagram, Zombie Mermaid alt [Success] [Insufficient funds] POST /transfer BEGIN Debit account A Credit account B INSERT audit_log COMMIT 200 OK ROLLBACK 400 Bad Request Client Server Database

More Sequence diagram examples