Multi Tenancy the right path ?
Hi all
I want to build a quick app to monitor my two children’s food intake and allergies.
One login for myself and wife so we can view the data.
Obviously I would like both children’s data to be separate.
I would be able to log food for the data and any symptoms they may have. Ideally with a dashboard to show the data.
Would multi tenant setup be the right way to go ? With each ‘team’ as a child ?
Or have I over complicated things ?
4 Replies
Depends, does the child need to login and fill there own data or are you putting all the data in?
if the child is putting all the data i personaly would go with multi tenant.
if you as parents are putting all the data than a regular install will do the trick,
I am doing all the inputting of the data. Kids are too young.
So you think a regular select dropdown on each entry to select a child. Then on the main dashboard have some sort of tab filter?
I just need to be able to distinguish results between the kids data
You can do tab filter on main dashboard.
You can als add data to 1 chart so you can see de graps per child
Thank you. Slightly diverging from the main topic but you seem to know you stuff. From a model perspective, I think I want to be able to view a Day entry of which would have multiple food entries and symptoms per child. Would you think in the database, Day, foodLog, symptomLog.
Day table with have child_id and date.
Log tables having a foreign key of the day_id.
Unless you can think of a simpler way do doing it?
Then on the dashboard (list view of the day table ) it can show an each row in the table as a Date with relationships to show the data of food etc in each row, acting as a timeline.
Can then also click the Day Page to see full info