traveler table structure#
THERE IS CURRENTLY NO DOCUMENTATION FOR THIS TABLE
Field |
Type |
NULL allowed |
Default Value |
Foreign key |
Description |
---|---|---|---|---|---|
traveler* |
INTEGER |
NO |
|||
hhold |
INTEGER |
NO |
0 |
||
person |
INTEGER |
NO |
0 |
||
tour |
INTEGER |
NO |
0 |
||
trip |
INTEGER |
NO |
0 |
||
mode |
INTEGER |
NO |
0 |
||
time |
REAL |
YES |
0 |
||
distance |
REAL |
YES |
0 |
||
speed |
REAL |
YES |
0 |
||
link |
INTEGER |
NO |
0 |
||
dir |
INTEGER |
NO |
0 |
||
lane |
INTEGER |
NO |
0 |
||
offset |
REAL |
YES |
0 |
||
route |
INTEGER |
NO |
0 |
(* - Primary key)
The SQL statement for table and index creation is below.
CREATE TABLE "Traveler" (
"traveler" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"hhold" INTEGER NOT NULL DEFAULT 0,
"person" INTEGER NOT NULL DEFAULT 0,
"tour" INTEGER NOT NULL DEFAULT 0,
"trip" INTEGER NOT NULL DEFAULT 0,
"mode" INTEGER NOT NULL DEFAULT 0,
"time" REAL NULL DEFAULT 0,
"distance" REAL NULL DEFAULT 0,
"speed" REAL NULL DEFAULT 0,
"link" INTEGER NOT NULL DEFAULT 0,
"dir" INTEGER NOT NULL DEFAULT 0,
"lane" INTEGER NOT NULL DEFAULT 0,
"offset" REAL NULL DEFAULT 0,
"route" INTEGER NOT NULL DEFAULT 0)