Database
Manage DB
Browse collections and tables, and watch the CQRS timing pipeline.
Eventsevents
A specific race contest within an EventGroup running over a Course.
π‘
Operational Purpose & Edge Invariants
The specific competitive race instance (e.g. '100 Mile Championship', '50K Solo', 'Pro Men DH'). Binds an EventGroup and a Course together with scheduled start times, lap counts, and registered entrants.
Relational Connections (3)
Table Columns & Types (8)
events| Column | PostgreSQL Type | Constraints | Default | Documentation |
|---|---|---|---|---|
| id | uuid | NOT NULLPK | gen_random_uuid() | Unique event identifier. |
| eventGroupId | uuid | NOT NULLFK -> eventGroups.id | β | Parent event group. |
| courseId | uuid | NOT NULLFK -> courses.id | β | Physical course. |
| name | text | NOT NULL | β | Race title (e.g. "100 Mile Championship"). |
| lapsRequired | integer | NOT NULL | 1 | Number of full course circuits required to complete the race. |
| scheduledStart | timestamp with time zone | NOT NULL | β | Official scheduled gun time. |
| actualStart | timestamp with time zone | nullable | β | Observed actual gun firing timestamp. |
| createdAt | timestamp with time zone | NOT NULL | now() | Creation timestamp. |
Database Indexes (2)
| Index Name | Columns | Type | Query Performance Rationale |
|---|---|---|---|
| events_group_idx | (eventGroupId) | INDEX | Accelerates retrieval of all race divisions within an event weekend. |
| events_course_idx | (courseId) | INDEX | Enables fast lookup of events sharing a specific course track. |