transit modes table structure

This table provides a mapping from GTFS modes to human readable labels and provides assumptions on standard operating costs by mode.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
mode_id*	INTEGER	YES			Mode ID as defined in GTFS
mode_name	TEXT	NO			Human readable mode name
operating_cost_per_hour	REAL	NO			Operating cost per hour in dollars

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS Transit_Modes(
    mode_id                 INTEGER PRIMARY KEY,
    mode_name               TEXT NOT NULL,
    operating_cost_per_hour REAL NOT NULL
);