Project database SQL data model

The data model presented in this section pertains only to the structure of AequilibraE’s ‘project_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

• about table structure
• attributes documentation table structure
• link types table structure
• links table structure
• matrices table structure
• modes table structure
• nodes table structure
• periods table structure
• results table structure
• scenarios table structure
• transit graph configs table structure
• zones table structure