I'm trying to build a data store for the GFTS static data, but can't get my head around the relationships between Route, Stop, Stop_Times and Trips.
Route 2E runs between airport and city centre. It has a fixed number of stops on this route. An instance of the 2E is a trip which leaves the airport at a certain time (9:30) to travel to the city. Its Stop times are the times that this trip specifically will be at designated stops.
However, this implies a link between Route and Stops. Route 2E has 12 stops between Airport and city. This never changes regardless of whether you catch the 9:30 trip or 11:30 trip.
So Stop Times are linked to Trip. But stops should linked to Routes. But every data model I have seen does not show the route stop relationship.
What am I missing ?