traveler table structure

traveler table structure#

THERE IS CURRENTLY NO DOCUMENTATION FOR THIS TABLE

Table Structure#

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)