zone tnc drs detour times table structure#
Table is currently unused Zone_TNC_DRS_Detour_Times stores the average detour experienced when using shared mobility services and pooling the ride when traveling aggregated by a combination of origin zone, destination zone, the time period of travel, and mode.
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
|---|---|---|---|---|---|
id* |
INTEGER |
NO |
|||
start |
INTEGER |
NO |
0 |
||
avg_detour_minutes |
REAL |
YES |
0 |
||
end |
INTEGER |
NO |
0 |
||
mode |
INTEGER |
NO |
0 |
||
o_zone |
INTEGER |
NO |
0 |
||
d_zone |
INTEGER |
NO |
0 |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Zone_TNC_DRS_Detour_Times" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"start" INTEGER NOT NULL DEFAULT 0,
"avg_detour_minutes" REAL NULL DEFAULT 0,
"end" INTEGER NOT NULL DEFAULT 0,
"mode" INTEGER NOT NULL DEFAULT 0,
"o_zone" INTEGER NOT NULL DEFAULT 0,
"d_zone" INTEGER NOT NULL DEFAULT 0)