Demand data model#
Demand data is stored in an SQLite database called “ModelName-Demand.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
Data tables#
- about model table structure
- activity table structure
- activity type table structure
- automation type table structure
- connectivity type table structure
- ev charging table structure
- ev features table structure
- fleet table structure
- fuel type table structure
- household table structure
- migrations table structure
- mm trip table structure
- mode table structure
- parking records table structure
- person table structure
- person gaps table structure
- plan table structure
- planned activity table structure
- powertrain type table structure
- selection table structure
- tnc request table structure
- tnc servicing table structure
- tnc trip table structure
- transit vehicle table structure
- transit vehicle links table structure
- traveler table structure
- trip table structure
- vehicle table structure
- vehicle class table structure
- vehicle type table structure
- vintage type table structure