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 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?
Was this page helpful?