The submissions table uses UUIDs as primary keys (~340M records). UUIDs are excellent for distributed ID generation but create a significant problem for systems that need sequential, ordered access to submissions — e.g., migration tooling, cursor-based pagination, or ordered event replay.
| Concern | UUID PK | Sequential integer |
|---|