Optimistic Lock Adapter

Infrastructure utility that implements optimistic concurrency control for the approval workflow, preventing two coordinators from simultaneously approving or rejecting the same activity record. Uses a version column on the activity_approvals table and throws a conflict error if the version has changed since the client last read the record.

Feature: Activity Review & Approval

optimistic-lock-adapter

• Provide version-checked write operations for approval records
• Detect and report concurrent modification conflicts
• Expose retry guidance in conflict error responses