Creating Organisations with User Permissions with Supabase (Auth)
For context, I'm building with Svelte 5 and Supabase.
I have it set up such that an individual can create an account and then fill in a survey, storing that data in a
Beyond that, however, one of the core functions of my application is for various organisations to ask questions of their own. With this in mind, some of my users will have admin/editor/moderator/contributor permissions for one or more organisations.
I want to know how I ought to structure this.
I presume I create an
Thanks!
I have it set up such that an individual can create an account and then fill in a survey, storing that data in a
responses table on Supabase. They can then view their data on my website's various pages. Beyond that, however, one of the core functions of my application is for various organisations to ask questions of their own. With this in mind, some of my users will have admin/editor/moderator/contributor permissions for one or more organisations.
I want to know how I ought to structure this.
I presume I create an
organisations table and then have columns for each of these permission levels, or a single team column that contains a JSON object. Is this correct, or is there a better way to achieve this? Thanks!
