Hi, I am a completely beginner in databases and backend. I am developing a flutter mobile app. This is my scenario, each user is a gym owner. Each gym owner has a list of lessons. For each lesson there will be the teacher, which is required and then the list of alumns that can be form 1 to 29. Teacher and alumns then have some attributes that are different.
I don't want to store teacher or alumns infos, for internal reasons every time the gym owner will have to manually write the attributes of the teacher and the alumns for every lesson.
At the moment each gym owner has only one gym but in the future i would like to provide multiple gyms for a single user.
What is the best way to structure my database ? I think i have to use relationships. In my scenario every time i will use teacher and alumns info in a couple of cloud functions and then i will mark the lesson as completed and erase all the lesson info except a few parameters for privacy reasons.
Recommended threads
- Invalid document structure: Unknown attr...
Hello. I have self hosted instance running on my server and has valid endpoint and most of things are working as should. Installation is fresh install of versio...
- Server side row delete error : "Server E...
when i try to delete the recored this error come and also there one things i have created the relationship with other table then deleted the column and still th...
- Why TablesDB ListRows function does not ...
When I try to list the rows with queries, there is no column data included in the returned value with forced me to fetch the items one-by-one with ID (which was...