fleet table structure

Table denotes the different fleets operating within the simulation. Can be a TNC fleet, transit fleet, or freight-related fleet.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
fleet*	INTEGER	NO			unique identifier denoting the fleet
name	TEXT	NO	‘’		text identifying the name of the fleet. Example includes “Operator_1”

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Fleet" (
  "fleet" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name" TEXT NOT NULL DEFAULT ''
)