Skip to content

graph db design

Bibiana Rivadeneira edited this page Jun 21, 2023 · 1 revision

Each node represents a bus station (for now of Flixbus) related each other with a relation called "CAN TRANSFER TO" as follows:

+--------------------------------------+
|            BusStationNode             |
+--------------------------------------+
| - station_id: int                    |
| - city: str                          |
| - region: str                        |
| - location: Location                 |
| - id_for_reach: int                  |
| - node_type: str                     |
| - service: str                       |
| - service_reachable_ids: array[int]  |
| - uuid_from_service: str             |
| - is_popular: bool                   |
+--------------------------------------+
+--------------------------------------+
|          NodeRelationShip             |
+--------------------------------------+
| - relation_name: str                 |
| - service: str                       |
| - schedules: array[datetime]         |
| - average_duration: duration         |
| - average_price: float               |
+--------------------------------------+

TODO:

  • add general cypher queries
Clone this wiki locally