Database
Manage DB
Browse collections and tables, and watch the CQRS timing pipeline.
⚡High-Performance Timing Domain Pipeline
CQRS ArchitectureChekkPoint cleanly separates continuous high-throughput hardware pulse ingestion (Write Plane) from calculated checkpoint leaderboards and split projections (Read Plane), governed by strict audit controls and multi-tenant hierarchies.
Hierarchy & Courses
Organizations host EventGroups containing Events. Courses map physical TimingPoints to logical CourseSplits. People register as Entrants.
Immutable UTC Pulses
RFID mats, lasers, ham radios, and offline PWAs append raw pulses. Zero updates or deletes. Replaces loose boolean flags with single-status validation.
Materialized Standings
Scoring workers project elapsed times, dwell seconds, and TSD penalties. Time allowances extend cutoffs; audits record every manual steward change.
Athletic Intelligence & SAR
Multi-source scraping (UltraSignup, Strava, DUV, ITRA) with MFDA disambiguation. Pacing models predict split arrival windows and flag SAR/cutoff risks.
All Domain Collections (21)
Click to inspect schema specification or live recordsOrganizationsorganizations
Root tenant entity representing governing bodies, race directors, and timing service companies.
Event Groupsevent_groups
The fundamental weekend/venue grouping sharing physical bib space, timing points, and volunteers.
Coursescourses
Physical course track, distance, elevation profile, and GPX navigation route file.
Eventsevents
A specific race contest within an EventGroup running over a Course.
Timing Pointstiming_points
Physical coordinates and ground hardware location where volunteers or transponder mats sit.
Course Splitscourse_splits
A logical milestone along a course at a cumulative distance, pointing to a physical TimingPoint.
Peoplepeople
Global human identity record with contact info, optionally linked to a login.
Entrantsentrants
The scored competitive unit in a race (Bib #, Plate #, or Car #) and polymorphic participant data.
Person External Profilesperson_external_profiles
External platform accounts (UltraSignup, Strava, DUV, ITRA) linked to an individual person.
Person Race Historyperson_race_history
Individual past race results, finishes, and DNFs achieved by a person across platforms and years.
Person Historical Summariesperson_historical_summaries
Materialized 1:1 career intelligence rollup for a person, computing experience tier and DNF risk.
Entrant Historical Projectionsentrant_historical_projections
Event-specific materialized pacing projections and volunteer safety badges for an entrant.
Raw Timing Eventsraw_timing_events
High-frequency ingestion ledger recording raw timing pulses in UTC with device telemetry.
Scored Split Timesscored_split_times
Materialized leaderboard standings, cumulative elapsed times, dwell seconds, and regularity penalties.
Time Allowancestime_allowances
Mandatory medical holds, safety stops, and hazard holds deducted from net elapsed time.
Split Time Auditssplit_time_audits
Forensic audit log capturing every manual status change, timestamp edit, or steward recalculation.
Usersusers
Login identities managed by Better Auth. Sessions, accounts, and verification tokens are not browsable here.
Organization Membersorganization_members
Which users belong to which organization, and with what roles.
Event Group Staffevent_group_staff
Volunteers, checkpoint captains, officials, and medical staff for an event group.
Staff Timing Pointsevent_group_staff_timing_points
Timing points each volunteer or checkpoint captain is stationed at.
Hello Worldhello_world
Starter demonstration table testing ElectricSQL sync, SQLite OPFS persistence, and live queries.