Hello,
I am very new to Supabase and Flutterflow but I'm learning as I go
I am trying to make an app (very simple with a few limited product categories) where users can list their product to sell and they can buy as well. I am having a little problem in setting up the backend part in Supabase. if there is someone who can share a detailed schema (database) setup for a similar app it would be a great help. I also have a table Listed_products (By a user/seller) and I have another table called Sellers (as a way to differentiate users and make a profile for the users who are selling products) I wanted to make a trigger and a function that adds a row into the Sellers table after a row is inserted in the Listed_products table, unfortunately its not working and I cant figure out why, BTW RLS disabled for all tables. My function is . Thank you all in advance
BEGIN INSERT INTO "Public.Sellers" (seller_id, product_id, Seller_email) VALUES (NEW.seller_id, NEW.product_id, NEW.Seller_email);
RETURN NEW;
END;