Table 3. Structure of MySQL database.
Table name | Purpose | Key | Other attributes |
bikeflow_cityID | Record for each distinct journey | Journey ID | Origin & destination stand IDs, start & end times |
bikeflow_cityID_namelocation | Information on stand geographies | Stand_ID | Latitude/longitude, descriptive name |
bikeflow_cityID_routing | Description of route through network between any pair of stands | Origin & destination stand IDs | Sequence of latitude/longitude pairs describing route between nodes |