💡 Research & document efficient DB schema workflow

[maxh1231]

DB requires nonoptimal and time-consuming maintenance when updating the schema.

The current workflow is as follows:

1. Delete profiles table
2. Delete users.
3. Delete on_auth_user_created trigger

This results in a inefficient workflow and deleting users may cause unexpected hiccups especially if more devs contribute to the project.

[Thenlie]

This can now be done using the Supabase CLI. We can create and test DB migrations locally and then push the migration up to the shared DB. We could even wrap this in a workflow when new migrations are detected in merges to dev/main.