Common ways to reference and work with the `user_id` when managed by Supabase
As far as I understood, it's a valid approach to keep user management and its related auth schemas the way Supabase provides it out of the box.
All my custom tables, and their schema, have been created/managed by drizzle.
I created a local
But when I migrate, it doesn't work; either I include the local
How can I make it work AND/OR what's the adviced approach to work in harmony with Supabase and its user management?
All my custom tables, and their schema, have been created/managed by drizzle.
I created a local
users table so I can reference it in my relations for joint queries, e.g. in toolsToQualitiesToUsersRelations.But when I migrate, it doesn't work; either I include the local
users table in my migration - which I don't want -, or it throws an error if I do not include it.How can I make it work AND/OR what's the adviced approach to work in harmony with Supabase and its user management?