Database

Manage DB

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

← Overview•Course & GeographyGround Station

Timing Points`timing_points`

Physical coordinates and ground hardware location where volunteers or transponder mats sit.

💡

Operational Purpose & Edge Invariants

TimingPoint represents a physical ground station (e.g. 'Twin Lakes Aid Station Tent' at GPS 39.08, -106.38). Hardware devices transmit raw pulses tagged with the TimingPoint code. Runners on out-and-back or multi-loop courses may pass the same physical TimingPoint multiple times under different CourseSplits.

Relational Connections (2)

↑ Belongs ToorganizationId

organizations →

Owning organization.

↓ Has ManytimingPointId

courseSplits →

Course splits mapped to this physical checkpoint location.

Table Columns & Types (8)

timing_points

Column	PostgreSQL Type	Constraints	Default	Documentation
id	uuid	NOT NULLPK	gen_random_uuid()	Unique timing point identifier.
organizationId	uuid	NOT NULLFK -> organizations.id	—	Owning organization.
name	text	NOT NULL	—	Descriptive name (e.g. "Twin Lakes Aid Station Tent").
code	text	NOT NULLUnique with organizationId	—	Short identifier transmitted by hardware or acoustic radio (e.g. "TWIN_LAKES").
latitude	double precision	nullable	—	WGS84 latitude coordinate.
longitude	double precision	nullable	—	WGS84 longitude coordinate.
elevationMeters	integer	nullable	—	Altitude above sea level in meters.
createdAt	timestamp with time zone	NOT NULL	now()	Creation timestamp.

Database Indexes (1)