Schema for GTFS real time

[rodrigowindows]

I would like to know if anyone has the database schema for GTFS real time? I plan to store the GTFS realtime data from an AVL system to a database and share it (Like MBTA feed API).
So far I have this python class that I will test soon (https://github.com/mattwigway/gtfsrdb/blob/master/model.py)

Thanks
Rodrigo

[tyleragreen]

If gtfsrdb is not working for you, you may consider posting your question to this group: https://groups.google.com/forum/#!forum/gtfs-realtime.

[rodrigowindows]

Hello Tyler,

I did the schema based on 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. I will post in the google groups as well.

Thanks Tyler!