transit zones table structure

Transit fare zones, when applicable, are listed in this table.

No geometry is provided, but the information of transit zone is also available on stops whenever fares are zone based for the agency in question.

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
transit_zone_id*	INTEGER	NO			transit zone ID in the format AA0000000 (Agency)
transit_zone	TEXT	NO			transit zone ID as seen in the GTFS
agency_id	INTEGER	NO		Transit_Agencies(agency_id)	ID of the agency serving the route

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE IF NOT EXISTS "Transit_Zones" (
    transit_zone_id INTEGER NOT NULL PRIMARY KEY,
    transit_zone    TEXT    NOT NULL,
    agency_id       INTEGER NOT NULL,

    FOREIGN KEY(agency_id) REFERENCES Transit_Agencies(agency_id) deferrable initially deferred
);