Database
Manage DB
Browse collections and tables, and watch the CQRS timing pipeline.
Staff Timing Pointsevent_group_staff_timing_points
Timing points each volunteer or checkpoint captain is stationed at.
π‘
Operational Purpose & Edge Invariants
Limits where a volunteer may record times and which entries a checkpoint captain may correct.
Relational Connections (2)
Table Columns & Types (2)
event_group_staff_timing_points| Column | PostgreSQL Type | Constraints | Default | Documentation |
|---|---|---|---|---|
| staffId | uuid | NOT NULLPKFK -> event_group_staff.id | β | Staff assignment. |
| timingPointId | uuid | NOT NULLPKFK -> timing_points.id | β | Timing point. |
Database Indexes (1)
| Index Name | Columns | Type | Query Performance Rationale |
|---|---|---|---|
| event_group_staff_timing_points_tp_idx | (timingPointId) | INDEX | Lists who is stationed at a timing point. |