Handling Deadlocks through Schema Design

Refactor schema access patterns to minimize cross-table locking and deadlock frequency.