micromobility agencies table structure

Lists all micro-mobility operators available in the model

The operator-id functions like the agency_id for public transport agencies and pre-fixes some fields in other related tables

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
agency	TEXT	NO			Name of the micromobility agency
agency_id*	INTEGER	NO			The unique identifier of the micromobility agency
description	TEXT	YES			A text based description of the agency (optional)

(* - Primary key)

The SQL statement for table and index creation is below.

create TABLE IF NOT EXISTS "Micromobility_Agencies" (
    agency      TEXT    NOT NULL,
    agency_id   INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    description TEXT
);

create UNIQUE INDEX IF NOT EXISTS micro_operators_id ON Micromobility_Agencies (agency_id);