# Best graph structure for appointment based graph?

**URL:** <https://community.neo4j.com/t/best-graph-structure-for-appointment-based-graph/60064>\
**Category:** Neo4j Graph Platform\
**Tags:** migrated\
**Created:** [September 3, 2021, 1:45am UTC](https://community.neo4j.com/t/best-graph-structure-for-appointment-based-graph/60064 "2021-09-03T01:45:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilyafish](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ilyafish/32/12174_2.png) [@ilyafish](https://community.neo4j.com/u/ilyafish)\
**Post date:** [September 3, 2021, 1:45am UTC](https://community.neo4j.com/t/best-graph-structure-for-appointment-based-graph/60064/1 "2021-09-03T01:45:02Z")

</div>

I'm creating a database that will be used for client appointments. The current structure I had in mind was:

(:User {userId: "Int", userFirstName: "String", userLastName: "String"})-[:HAS\_ACTIVITY {activityType: "String"}]-\>(:Activity {activityId: "Int", startTime: "DateTime", endTime: "DateTime"})

Most common use cases will be querying what Activities a User has today, has in the future, and had in the past(filter activities by date range). Activities are blocks of time like a regular calendar. Also will be querying today/upcoming/past activities per Client. This query is more for occasional analytics to see which Client has the most and least activities, not so much a frequently run query.

Is it still best practice to structure this by creating a Year, Month, Day, Hour, Minute (5 minute intervals so 12 nodes) path tree such as indicated here: [6.13. A multilevel indexing structure (path tree) - - The Neo4j Manual v2.3.3](https://neo4j.com/docs/stable/cypher-cookbook-path-tree.html)

Or have things changed and keeping startTime/endTime properties on each Activity node as I currently have above is ok also? I'm importing a pretty large dataset so there will be 10,000 + activities

---

<div class="post-metadata">

**Author:** ![support1](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/support1/32/3875_2.png) [@support1](https://community.neo4j.com/u/support1)\
**Post date:** [July 14, 2022, 1:26pm UTC](https://community.neo4j.com/t/best-graph-structure-for-appointment-based-graph/60064/2 "2022-07-14T13:26:53Z")

</div>

I too would like to know more. What does NEO4J recommend in terms of using neo4j as a calendar/appointment solution? Or would it recommend using an alternative traditional DB and linking to it?