Database

Manage DB

Browse collections and tables, and watch the CQRS timing pipeline.

← Overview•Course & GeographyPhysical Track

Courses`courses`

Physical course track, distance, elevation profile, and GPX navigation route file.

💡

Operational Purpose & Edge Invariants

Defines the immutable physical track for an athletic competition. Distinct from an Event (which has a scheduled time and competitors) and CourseSplits (which are logical checkpoints along this course). Can be reused year over year or across multiple events.

Relational Connections (5)

↑ Belongs ToorganizationId

organizations →

Owning organization.

↑ Belongs TocopiedFromCourseId

courses →

Source template or previous edition course this course was copied from.

↓ Has ManycopiedFromCourseId

courses →

Derived courses created by copying this course layout.

↓ Has ManycourseId

events →

Races running along this physical course.

↓ Has ManycourseId

courseSplits →

Checkpoints and milestone splits defined along this course.

Table Columns & Types (8)

courses

Column	PostgreSQL Type	Constraints	Default	Documentation
id	uuid	NOT NULLPK	gen_random_uuid()	Unique course identifier.
organizationId	uuid	NOT NULLFK -> organizations.id	—	Owning organization.
name	text	NOT NULL	—	Course title (e.g. "Western States 100 Trail").
distanceMeters	double precision	NOT NULL	—	Official measured course distance in meters.
elevationGainMeters	integer	nullable	—	Cumulative positive elevation gain in meters.
gpxRouteUrl	text	nullable	—	Public URL to the official GPX elevation route file.
copiedFromCourseId	uuid	nullableFK -> courses.idON DELETE SET NULL	—	Optional reference to the source course from which this course was cloned or derived.
createdAt	timestamp with time zone	NOT NULL	now()	Creation timestamp.

Database Indexes (2)