Skip to main content
. 2013 Sep 6;8(9):e74685. doi: 10.1371/journal.pone.0074685

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