Swap to uuid primary keys

[AidanLoran]

Description

Many of our db tables use int autoincrement primary keys. They should be swapped to using uuids. This will also affect the typings of anything that handles those keys.

TODO

• Make the change db level
• Fix the new discrepencies code-level
  • zod schemas
  • api handlers
  • composables
  • other
• Verify functionality