Freight data model

Freight data model#

Freight data is stored in an SQLite database called “ModelName-Freight.sqlite”. This section will document the structure and purpose of the tables in that database.

Conventions#

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

  • Geometry field is always called geo

  • Projection is always planar and in meters

  • Tables required by the data model have capital first letter

  • ID columns are named similarly to the table but lower case (i.e. the railport column in the Railport table is the unique key column)

  • Foreign key columns are also similarly named (i.e. the ‘firm’ column in the Establishment table is a foreign key to the firm ID column in the Firm table)```

Data tables#