GTFS Archiver
mysql> show columns in alert;
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| cause | varchar(20) | YES | | NULL | |
| description_text | longtext | YES | | NULL | |
| effect | varchar(20) | YES | | NULL | |
| header_text | varchar(80) | YES | | NULL | |
| timestamp | datetime | YES | | NULL | |
| url | longtext | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
mysql> show columns in entity_selector;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| agency_id | varchar(15) | YES | | NULL | |
| route_id | varchar(20) | YES | | NULL | |
| route_type | bigint(20) | YES | | NULL | |
| stop_id | varchar(20) | YES | | NULL | |
| trip_id | varchar(20) | YES | | NULL | |
| trip_route_id | varchar(20) | YES | | NULL | |
| trip_start_date | varchar(10) | YES | | NULL | |
| trip_start_time | varchar(8) | YES | | NULL | |
| alert_id | bigint(20) | NO | MUL | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
mysql> show columns in time_range;
+------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| time_end | bigint(20) | YES | | NULL | |
| time_start | bigint(20) | YES | | NULL | |
| alert_id | bigint(20) | NO | MUL | NULL | |
+------------+------------+------+-----+---------+----------------+
mysql> show columns in trip_update;
+-----------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| route_id | varchar(20) | YES | | NULL | |
| schedule_relationship | int(11) | NO | | NULL | |
| timestamp | datetime | YES | | NULL | |
| trip_id | varchar(20) | YES | | NULL | |
| trip_start | datetime | YES | | NULL | |
| vehicle_id | varchar(20) | YES | | NULL | |
| vehicle_label | varchar(20) | YES | | NULL | |
| vehicle_license_plate | varchar(15) | YES | | NULL | |
+-----------------------+-------------+------+-----+---------+----------------+
mysql> mysql> show columns in stop_time_update;
+-----------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| arrival_delay | int(11) | YES | | NULL | |
| arrival_time | datetime | YES | | NULL | |
| arrival_uncertainty | int(11) | YES | | NULL | |
| departure_delay | int(11) | YES | | NULL | |
| departure_time | datetime | YES | | NULL | |
| departure_uncertainty | int(11) | YES | | NULL | |
| schedule_relationship | int(11) | NO | | NULL | |
| stop_id | varchar(20) | YES | | NULL | |
| stop_sequence | bigint(20) | YES | | NULL | |
| trip_update_id | bigint(20) | NO | MUL | NULL | |
+-----------------------+-------------+------+-----+---------+----------------+
mysql> show columns in vehicle_position;
+-----------------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| bearing | float | YES | | NULL | |
| lat | float | YES | | NULL | |
| lon | float | YES | | NULL | |
| route_id | varchar(20) | YES | | NULL | |
| speed | float | YES | | NULL | |
| timestamp | datetime | YES | | NULL | |
| trip_id | varchar(20) | YES | | NULL | |
| trip_start | datetime | YES | | NULL | |
| vehicle_id | varchar(20) | YES | | NULL | |
| vehicle_label | varchar(20) | YES | | NULL | |
| vehicle_license_plate | varchar(15) | YES | | NULL | |
+-----------------------+-------------+------+-----+---------+----------------+