However the id in the table doesn't have a default value of

uuid()

, am I missing something here?

I believe the UUID / CUIDs are generated on runtime by Prisma Client (or Prisma’s engine) meaning the column in the table will not actually have a default value. autoincrement IDs should be taken care of automatically by your database.

I will try to finish the API to confirm this 😉 But I think you are right. I just don't understand what the reason behind this is since there is a uuid module for postgres