Best way to add social accounts to a person
I am working on a small app right now with NextJS that basically has 2 parts. There is a public/client facing landing page where information from the database will be displayed. The page will contain a basic message, contact information, and links to their social accounts.
The other part is an admin only page (registered supabase users) with a form for creating new clients.
I set up a table named "clients" that has all of the necessary columns (name, message, street, city) except for their social media links. I am a bit stuck on how to proceed with this at the moment. My first thought was to just have preset social columns in the table and have the form write directly to those. However, I am thinking I might run into some issue down the line where the I have not accounted for a type of account. Should I just use an array on varchar with objects, or is there a better way to go about this? I do apologize if this confusing. If any more clarification is needed please let me know!
The other part is an admin only page (registered supabase users) with a form for creating new clients.
I set up a table named "clients" that has all of the necessary columns (name, message, street, city) except for their social media links. I am a bit stuck on how to proceed with this at the moment. My first thought was to just have preset social columns in the table and have the form write directly to those. However, I am thinking I might run into some issue down the line where the I have not accounted for a type of account. Should I just use an array on varchar with objects, or is there a better way to go about this? I do apologize if this confusing. If any more clarification is needed please let me know!
