I’m building a tool where at one point you’d have an itinerary of a trip you’re preparing.
It would look something like this:
I’m wondering what’s the best way to structure my database, and how to build.
This is not just to display the info, the tool would help you build your itinerary. So a day can have 1,2,3,4 or 5 activities, 1 accommodation, 0 or 1 transport.
Activities could also be moved from day 1 to day 3, or day 1 “slot” 1 to day 1 slot 3… quite complicated database wise.
And once we set the database, I feel it’s going to be repeating groups inside repeating groups inside repeating groups… might not be great
Many thanks for any input, because I don’t know where to start!