TIDES Tables Overview Flashcards
(33 cards)
What is the vehicle_locations table?
Timestamped vehicle locations and speeds
What is the passenger_events table?
Timestamped passenger-related events, including boardings and alightings
What is the fare_transactions table?
Timestamped fare transactions, associated with devices
What is the stop_visits table?
Summarized boarding, alighting, arrival, departure, and other events by trip and stop for each service date
What is the trips_performed table?
Trips performed for each service date
What is the station_activities table?
Summarized transactions, entries, and exits by stop or station and time period for each service date (for events not associated with a trip)
What is the devices table?
Measurement devices, such as AVL, APC, and AFC devices, associated with vehicles or stops or stations
What is the train_cars table?
Assets that comprise vehicles, such as train cars, with descriptive information
What is the vehicle_train_cars table?
Relationships between assets and vehicles
What is the vehicles table?
Vehicles, including buses and train consists, with descriptive information
What is the operators table?
Personnel who operate vehicles
What is the primary key for the vehicle_locations table?
location_ping_id
What is the primary key for the passenger_events table?
passenger_event_id
What is the primary key for the fare_transactions table?
transaction_id
What is the primary key for the stop_visits table?
service_date, trip_id_performed, trip_stop_sequence
What is the primary key for the trips_performed table?
service_date, trip_id_performed
What is the primary key for the station_activities table?
service_date, stop_id, time_period_start, time_period_end
What is the primary key for the devices table?
device_id
What is the primary key for the train_cars table?
train_car_id
What is the primary key for the vehicle_train_cars table?
vehicle_id, train_car_id
What is the primary key for the vehicles table?
vehicle_id
What is the primary key for the operators table?
operator_id
What is the table type for vehicle_locations?
Event
What is the table type for passenger_events?
Event
