I am trying to build an applicant tracking system where companies can invite candidates (using a shareable link) to apply for jobs. I also want companies to be able to add team members who can also add and see jobs other team members add and I'm struggling to figure out how to build this functionality from a database perspective considering I want multiple businesses to be able to use the tool but only have access to their data. I started with Supabase and moved to Firebase because of the native integration but I'm not having much luck.
I have built this app on Bubble using their native database but I am really loving FlutterFlow and want to build it here to futureproof.
So after all that here are my questions
Best database structure for my use case?
how can I insert documents from inputs in the app into subcollections.
Is there a way to create a shareable link that candidates could use to view a job once shared by the team that would prompt the candidate to create a profile and go through a process to apply after signing up?
I know there's a lot there so pointers on any of the above would be amazing!
Thanks in advance for any advice 👍