Database
- 10_db tables
- 11_interfaces tables
- 12_security tables
- 13_dblog tables
- 15_server tables
- 16_impex tables
- 17_messages tables
- 20_tree tables
- 31_calendar tables
- 32_geography tables
- 34_road tables
- 35_pt tables
- 36_cms tables
- 37_pt_operation tables
- 51_resa tables
- 52_forum tables
- 54_departure_boards tables
- 55_timetables tables
- 56_pt_services_configuration tables
- 58_hiking tables
| Table | Module | Status | Since version | Object class | Table class |
|---|---|---|---|---|---|
| t001_object_site_links | Transport website | In use (old gen) | ObjectSiteLink | ObjectSiteLinkTableSync | |
| t002_addresses | 34_road | In use (old gen) | Address | ||
| t003_alarms | 17_messages | In use (old gen) | Alarm | ||
| t004? | |||||
| 35_pt tables | Abandoned | ||||
| t006_cities | 34_road | In use (old gen) | City | ||
| t007_connection_places | 35_pt tables | In use (old gen) | StopArea | ||
| t008_fares | 35_pt tables | In use (old gen) | Fare | FareTableSync | |
| t009_lines | 35_pt tables | In use (old gen) | JourneyPattern | ||
| t010_line_stops | 35_pt tables | In use (old gen) | LineStop | ||
| t011_place_aliases | 32_geography | In use (old gen) | PlaceAlias | ||
| t012_physical_stops | 35_pt tables | In use (old gen) | StopPoint | ||
| t013_public_places | 32_geography | In use | PublicPlace | ||
| t014_road_chunks | 34_road | In use (old gen) | RoadChunk | ||
| t015_roads | 34_road | In use (old gen) | Road | ||
| t016_scheduled_services | 35_pt tables | In use (old gen) | ScheduledService | ||
| t017_continuous_services | 35_pt tables | In use (old gen) | ContinuousService | ||
| t018? | |||||
| t019? | |||||
| t020? | |||||
| t021_reservation_contacts | 35_pt tables | In use | ReservationContact | ||
| t022_transport_networks | 35_pt tables | In use (old gen) | TransportNetwork | ||
| t023_interface_pages | 11_interfaces | Deprecated | InterfacePage | ||
| t024_interfaces | 11_interfaces | Deprecated | Interface | ||
| t025_sites | 36_cms | In use | Site | ||
| t026_users | 12_security | In use (old gen) | User | ||
| t027_profiles | 12_security | In use (old gen) | Profile | ||
| t028_account | 57_accounting | Stalled | Account | ||
| t029_currencies | 57_accounting | Stalled | Currency | ||
| t030_transaction_parts | 57_accounting | Stalled | TransactionPart | ||
| t031_transactions | 57_accounting | Stalled | Transaction | ||
| t032 to t035 | Reserved | ||||
| t036_display_types | 54_departure_table | In use (old gen) | DisplayType | ||
| t037? | |||||
| t038_text_templates | 54_departure_table | Deprecated | TextTemplate | ||
| t039_scenarios | 17_messages | In use (old gen) | Scenario | ||
| t040_alarm_object_links | 17_messages | In use (old gen) | AlarmObjectLink | ||
| t041_display_screens | 54_departure_table | In use (old gen) | DisplayScreen | ||
| t042_commercial_lines | 35_pt tables | In use (old gen) | CommercialLine | ||
| t043_crossings | 34_roads | In use (old gen) | Crossing | ||
| t044_reservations | 51_resa | In use (old gen) | Reservation | ||
| t045_log_entries | 13_dblog | In use (old gen) | LogEntry | ||
| t046_reservation_transactions | 51_resa | In use (old gen) | ReservationTransaction | ||
| t047_online_reservation_rules | 51_resa | In use (old gen) | OnlineReservationRule | ||
| t048_user_favorite_journeys | 56_pt_website | In use (old gen) | UserFavoriteJourney | ||
| t049_rolling_stock | 35_pt tables | In use (old gen) | RollingStock | ||
| t050? | |||||
| t051_scenario_folders | 17_messages | In use (old gen) | ScenarioFolder | ||
| t052_timetables | 55_timetable | In use (old gen) | Timetable | ||
| t053_timetable_rows | 55_timetable | In use (old gen) | TimetableRows | ||
| t054_calendar_templates | 19_calendar | In use (old gen) | CalendarTemplate | ||
| t055_calendar_template_elements | 19_calendar | In use (old gen) | CalendarTemplateElement | ||
| t056_non_concurrency_rules | 35_pt tables | In use (old gen) | NonConcurrencyRule | ||
| t057_display_monitoring_status | 54_departure_table | In use (old gen) | DisplayMonitoringStatus | ||
| t058_display_screen_cpu | 54_departure_table | In use (old gen) | DisplayScreenCPU | ||
| t059_data_sources | 16_impex | In use | DataSource | ||
| t060_road_places | 34_road | In use (old gen) | RoadPlace | ||
| t061_pt_use_rules | 35_pt tables | In use (old gen) | PTUseRule | ||
| t062_rolling_stock_filters | 56_pt_website | In use (old gen) | RollingStockFilters | ||
| t063_web_pages | 36_cms | In use | Webpage | ||
| t064_hiking_trails | 58_hiking | In progress | HikingTrail | ||
| t065_city_aliases | 32_geography | In use (old gen) | CityAlias | ||
| t066_junctions | 35_pt tables | In use (old gen) | Junction | ||
| t067_forum_topics | 52_forum | In use (old gen) | ForumTopic | ||
| t068_forum_messages | 52_forum | In use (old gen) | ForumMessage | ||
| t069_vehicles | 37_pt_operation tables | In use (old gen) | Vehicle | ||
| t070_compositions | 37_pt_operation tables | In use (old gen) | Composition | ||
| t071_drt_areas | 35_pt tables | In use (old gen) | DRTArea | DRTAreaTableSync | |
| t072_vehicle_positions | 37_pt_operation tables | In use (old gen) | |||
| t075_map_sources | 32_geography | In use (old gen) | |||
| t076_service_calendar_links | 35_pt tables | In use (old gen) | ServiceCalendarLink | ||
| t077_vehicle_services | 37_pt_operation tables | In use (old gen) | VehicleService | VehicleServiceTableSync | |
| t079_operators | 35_pt tables | To do | PTOperator | PTOperatorTableSync | |
| t078_houses | 34_road | In use (old gen) | House | HouseTableSync | |
| t080_dead_runs | 37_pt_operation tables | In use (old gen) | DeadRun | DeadRunTableSync | |
| t081_driver_services | 37_pt_operation tables | In use (old gen) | |||
| t082_city_wide_drt_areas | 35_pt tables | In use (old gen) | |||
| t083_free_drt_services | 35_pt tables | In use (old gen) | |||
| t084_public_place_entrances | 34_road | In use | |||
| t085_driver_allocations | 37_pt_operation tables | In use | |||
| t086_pt_services_configurations | 56_pt_website | In use | |||
| t087_driver_activites | 37_pt_operation tables | In use | |||
| t088_driver_allocation_templates | 37_pt_operation tables | In use | |||
| t089_service_quotas | 35_pt tables | In use | |||
| t090_timetable_rowgroups | 55_timetables tables | In use | |||
| t091_timetable_rowgroup_items | 55_timetables tables | In use | |||
| t092_tree_folders | 20_tree tables | In use | |||
| t093_inter_synthese_slaves | 19_inter_synthese | In use | |||
| t094_inter_synthese_configs | 19_inter_synthese | In use | |||
| t095_inter_synthese_config_items | 19_inter_synthese | In use | |||
| t096_inter_synthese_queue | 19_inter_synthese | In use | |||
| t097_vdv_servers | 61_data_exchange | In use | |||
| t098_vdv_server_subscriptions | 61_data_exchange | In use | |||
| t099_vdv_clients | 61_data_exchange | In use | |||
| t100_accessibility_profiles | 56_pt_website | In progress | |||
| t101_message_types | 17_messages | In progress | |||
| t102_message_aternatives | 17_messages | In progress | |||
| t103_website_configs | 11_cms | In progress | |||
| t104_message_application_periods | 17_messages | In progress | |||
| t105_imports | 16_impex | In progress | |||
| t106_custom_broadcast_points | 17_messages | In progress | |||
| t107_mailing_lists | 56_pt_website | In progress | |||
| t108_mailing_list_subscriptions | 56_pt_website | In progress | |||
| t109_messages_sections | 17_messages | In progress | |||
| t110_scenario_calendars | 17_messages | In progress | |||
| t111_inter_synthese_packages | 19_inter_synthese | In progress | |||
| t112_opening_times | 60_analysis | In progress | |||
| t113_traffic_forecasts | 60_analysis | In progress | |||
| t114_service_traffic_forecasts | 60_analysis | In progress | |||
| t115_permanent_threads | 15_server | In progress | |||
| t116_operation_units | 37_pt_operation | In use | |||
| t117_vehicle_service_usages | 60_analysis | In use | |||
| t118_descents | 38_vehicle | In use | |||
| t119_vehicle_calls | 38_vehicle | In progress | VehicleCall | VehicleCallTableSync |
| t999_config | In use |