zone tnc revenue table structure

Zone_TNC_Revenue contains information of the aggregated revenue earned by shared mobility operators in each zone at every hour of the day. The surge factor imposed by travel from a particular origin zone is also logged for each hour in the day in the same record.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
id*	INTEGER	NO			Record identifier
zone	INTEGER	NO	0		0-ordered zone ID (for 0 through n-1 zones)
hour	INTEGER	NO	0		Integer value (starting at 0) representing the starting hour of day for which the information is logged
surge_factor	REAL	YES	0		Surge factor observed for zone
revenue	REAL	YES	0		Revenue earned by all shared mobility operators for the specific hour in the specific zone

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE "Zone_TNC_Revenue" (
  "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  "zone" INTEGER NOT NULL DEFAULT 0,
  "hour" INTEGER NOT NULL DEFAULT 0,
  "surge_factor" REAL NULL DEFAULT 0,
  "revenue" REAL NULL DEFAULT 0)