So my app currently allows users to create an account → add multiple pet profiles that are then related to that user.
I would like to on signup, a "signup wizard to popup where they have the option to do the following:
Fill in a popup for their name
Select if they have a pet already registered (by another family member)
2.2 if yes, somehow link them to the other user?
I would need to somehow verify this I presume. May be better to have family members invite others, if so again, how could I do this and link the related pet profiles?
You’ll want some sort of family ID. I imagine two tables:
a users table, where you have a role column that can serve as the family ID.
A pets table with the same family ID column.
To add a new user to serve as an admin for the pets, the original user of the family needs to invite the new user. This will add to their row to the users table, and the family ID to the Role column.
They’ll automatically be linked to any related pets