TrailTastic Logo

TrailTastic Firestore Schema

Official database structures, subcollections, and relationship diagrams

arrow_back Back to Summary

hub Database Entity Relationships

Visual diagram of active production collections and their relationships in Firestore.

users Root Coll

Stores rider profile details and app navigation preferences.

↳ equipment Subcollection

Registered vehicles, tools, and ride equipment.

trailSystems Root Coll

Core geographic systems containing trail overlay routes.

↳ trails Subcollection

Individual geometry tracks drawn inside the system.

waypoints / trailIssues Linked via systemId
tracks Root Coll

Recorded rider telemetry GPX logs linked to ownerId & trailSystem.

feedback Root Coll

App feature suggestions and bug reports.

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.

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.

report_problem trailIssues

/trailIssues/{issueId} expand_more

Stores rider-reported trail hazards, washouts, downed trees, and maintenance reports.

science Planned Features & Schema Roadmap

Experimental structures, feature brainstorms, and work-in-progress collections reserved for future releases.

Future Roadmap

movie tracksVideo In Development

/tracksVideo/{id}

Designed to link video assets, offset markers, and multi-segment playback configs to ride tracks for video map synchronization features.

Fields: trackId, youtubeVideoId, startOffsetSeconds, localVideoName, videoSegments [ ]

card_membership subscriptions Future Brainstorm

/users/{uid}/subscriptions/{systemId}

Proposed user subcollection for managing paid trail system subscriptions, start/end validity dates, auto-renew status, and offline trailhead access tokens.

Fields: trailSystemId, status, startDate, endDate, autoRenew, paymentProvider