text: Title: Switch from UUID v4 to v7
  Body: **Describe the solution you'd like**
  Migrate to using UUID v7 (`uuid6` package, which despite its name provides `uuid7()` fn) as data type for `id` columns.
  
  **Additional context**
  These articles outline advantages of v7 (as opposed to v4), and also some pitfalls of not doing so:
  
  [Link 1](https://www.toomanyafterthoughts.com/uuids-are-bad-for-database-index-performance-uuid7) comes with very detailed information about all UUID implementations (benchmarks included), [Link 2](https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql) provides a well-rounded writeup on implications for PostgreSQL in particular!
  
  