Public Transport SQL Data model

The data model presented in this section pertains only to the structure of AequilibraE’s ‘public_transport’ database and general information about the usefulness of specific fields, especially on the interdependency between tables.

Conventions

A few conventions have been adopted in the definition of the data model and some are listed below:

• Geometry field is always called geometry

• Projection is 4326 (WGS84)

• Tables are all in all lower case

Project tables

• agencies table structure
• attributes documentation table structure
• fare attributes table structure
• fare rules table structure
• fare zones table structure
• link types table structure
• links table structure
• modes table structure
• node types table structure
• nodes table structure
• pattern mapping table structure
• results table structure
• route links table structure
• routes table structure
• stop connectors table structure
• stops table structure
• trigger settings table structure
• trips table structure
• trips schedule table structure