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 choice records 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