zone mm supply table structure

The Zone_MM_Supply table records the number of escooter available by zone and time of the day.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
id*	INTEGER	NO			The unique identifier of escooter availability by zone and time of day
zone	INTEGER	NO	0		0-based identifier (for zones 0 through n-1)
hour	INTEGER	NO	0		Integer representing starting hour of the day, the duration of which information is logged
escooter_availability	INTEGER	NO	0		Number of escooters available in the zone within the simulation (scaling needs to be considered if using for analysis)
avg_walk_access_minutes	REAL	YES	0		Average walking time to access an escooter in minutes

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Zone_MM_Supply" (
  "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "zone" INTEGER NOT NULL DEFAULT 0,
  "hour" INTEGER NOT NULL DEFAULT 0,
  "escooter_availability" INTEGER NOT NULL DEFAULT 0,
  "avg_walk_access_minutes" REAL NULL DEFAULT 0
  )