Database Schema - GTFS Real Time

unread,

Oct 2, 2016, 1:37:56 PM10/2/16

to GTFS-realtime

Hello,

I did the GTFS RT schema based on GTFSrDB (https://github.com/mattwigway/gtfsrdb):

I am not sure if the relations between the tables "alerts" with "entity_selectors" and "trip_updates" with "stop_time_updates" are 1:1 or 1:N.

Thanks,

Rodrigo Alves

unread,

Oct 3, 2016, 1:19:35 PM10/3/16

to GTFS-realtime

Rodrigo,

Both alerts:entity_selectors and trip_updates:stop_time_updates are 1:N.

The Cardinality of Alert.informed_entity:

...and TripUpdate.stop_time_update:

...are both "Repeated", which means more than one of these objects can appear in Alerts and TripUpdates feeds respectively.

Sean

unread,

Oct 3, 2016, 5:04:56 PM10/3/16

to GTFS-realtime

Hello Sean,

Thank you for clarifying it!

Rodrigo

Reply all

Reply to author

Forward