Skip to main content
`Ctrl`+`K`

# fare zones table structure

The fare_zones table hold information on the transit fare zones and the transit agencies that operate in it.

transit_fare_zone identifies the transit fare zones

agency_id identifies the agency/agencies for the specified fare zone

Field | Type | NULL allowed | Default Value
--- | --- | --- | ---
transit_fare_zone | TEXT | NO |
agency_id | INTEGER | NO |

(* - Primary key)

The SQL statement for table and index creation is below.

    CREATE TABLE IF NOT EXISTS fare_zones (
         transit_fare_zone    TEXT    NOT NULL,
         agency_id            INTEGER NOT NULL,
         FOREIGN KEY(agency_id) REFERENCES agencies(agency_id) deferrable initially deferred
    );