Comment by kangmingtay

supabase auth stores your users in the same database created, just in a separate schema so you have full access to it to perform joins or enforce referential integrity.