plan table structure

plan table structure#

THERE IS CURRENTLY NO DOCUMENTATION FOR THIS TABLE

Table Structure#

Field

Type

NULL allowed

Default Value

Foreign key

Description

plan*

INTEGER

NO

depart

REAL

YES

0

arrive

REAL

YES

0

activity

REAL

YES

0

walk

REAL

YES

0

drive

REAL

YES

0

transit

REAL

YES

0

wait

REAL

YES

0

other

REAL

YES

0

length

REAL

YES

0

cost

REAL

YES

0

impedance

INTEGER

NO

0

leg_mode

INTEGER

NO

0

leg_type

INTEGER

NO

0

leg_id

INTEGER

NO

0

leg_time

REAL

YES

0

leg_length

REAL

YES

0

leg_cost

REAL

YES

0

leg_imp

INTEGER

NO

0

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Plan" (
  "plan" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "depart" REAL NULL DEFAULT 0,
  "arrive" REAL NULL DEFAULT 0,
  "activity" REAL NULL DEFAULT 0,
  "walk" REAL NULL DEFAULT 0,
  "drive" REAL NULL DEFAULT 0,
  "transit" REAL NULL DEFAULT 0,
  "wait" REAL NULL DEFAULT 0,
  "other" REAL NULL DEFAULT 0,
  "length" REAL NULL DEFAULT 0,
  "cost" REAL NULL DEFAULT 0,
  "impedance" INTEGER NOT NULL DEFAULT 0,
  "leg_mode" INTEGER NOT NULL DEFAULT 0,
  "leg_type" INTEGER NOT NULL DEFAULT 0,
  "leg_id" INTEGER NOT NULL DEFAULT 0,
  "leg_time" REAL NULL DEFAULT 0,
  "leg_length" REAL NULL DEFAULT 0,
  "leg_cost" REAL NULL DEFAULT 0,
  "leg_imp" INTEGER NOT NULL DEFAULT 0
)