TrailTastic Logo

TrailTastic Firestore Schema

Official database structures, subcollections, and relationship diagrams

arrow_back Back to Viewer

hub Database Entity Relationships

Visual model of how documents map to and reference each other in Firestore.

tracks Root Coll

Stores clean ride telemetry (GPX metadata) with ownership details.

1 : 0..1 relationship
tracksVideo Root Coll

Links to track via trackId

trailSystems Root Coll

Core geographic systems containing trail overlay routes.

↳ trails Subcollection

Individual geometry tracks drawn inside the system.

waypoints Root Coll

References parent system using trailSystemId.

group users

/users/{uid} expand_more

Stores profile details and global application settings for registered riders.

route tracks

/tracks/{trackId} expand_more

Stores recorded rider logs, GPX source storage references, and ride statistics. Video configurations have been migrated to the separate `tracksVideo` collection.

movie tracksVideo

/tracksVideo/{id} expand_more

New collection linking video assets, offsets, and multi-segment playback configs to their parent tracks.

map trailSystems

/trailSystems/{systemId} expand_more

Geographic system settings defining center bounds, image maps, and administrative access UIDs.

location_on waypoints

/waypoints/{docId} expand_more

Geographic locations of obstacles, scenic lookouts, campsites, and intersections.

rate_review feedback

/feedback/{docId} expand_more

Stores rider feedback reports, bug reports, and features suggestions submitted from the site.