So i want to make an app for my University Thesis where the user can add different locations from one city. This app will calculate the best route based on distance and time (distance from one location to another, and time spend in traffic and in queues at these locations). Basically, for example if I wanna see Sagrada Familia, Park Guell and Casa Battlo in the same day, my app will show me where to go first, the best location at a certain time, where there is the minimum queue of people and where to go next, so I can see all these locations in the same day and spend minimum to no time in traffic and on queue.
I want to use Mongo Db. How my tables should look like? Till now I have:
- Users(name,email,password,isAdmin) -This table will store information about each user
- Locations(name,adress,latitude,longitude) -This table will store information about the different locations that users can select for their itinerary,
- Queue(locationName,timestamp,duration)
- Itineraries(startDate,endDate,distance,duration) -This table will store information about each itinerary that a user creates
I know i have to filter the best time but I don't really know how to make my databse. Should I put the queques in a different table? Or in locations table?
