Database
Manage DB
Browse collections and tables, and watch the CQRS timing pipeline.
Organizationsorganizations
Root tenant entity representing governing bodies, race directors, and timing service companies.
π‘
Operational Purpose & Edge Invariants
The top-level organizational umbrella in ChekkPoint. All event groups, courses, and ground timing points cascade down from an organization. This multi-tenant boundary isolates configuration and ensures authorization barriers between race directors.
Relational Connections (4)
β Has ManyorganizationId
eventGroups βEvent weekends and race groups hosted by this organization.
β Has ManyorganizationId
courses βStandardized courses and GPX tracks curated by this organization.
β Has ManyorganizationId
timingPoints βPhysical timing hardware and checkpoint stations owned/managed by this organization.
β Has ManyorganizationId
organizationMembers βUsers who belong to this organization, with their roles.
Table Columns & Types (7)
organizations| Column | PostgreSQL Type | Constraints | Default | Documentation |
|---|---|---|---|---|
| id | uuid | NOT NULLPK | gen_random_uuid() | Unique tenant identifier. |
| name | text | NOT NULL | β | Display name of the organization (e.g. "Wasatch Mountain Club"). |
| slug | text | NOT NULLUnique | β | URL-safe routing identifier used in tenant subdomains or paths. |
| logo | text | nullable | β | Logo URL (Better Auth organization plugin). |
| metadata | text | nullable | β | Serialized JSON metadata (Better Auth organization plugin). |
| createdAt | timestamp with time zone | NOT NULL | now() | UTC registration timestamp. |
| updatedAt | timestamp with time zone | NOT NULL | now() | UTC last modification timestamp. |
Database Indexes (1)
| Index Name | Columns | Type | Query Performance Rationale |
|---|---|---|---|
| organizations_slug_unique | (slug) | UNIQUE | Ensures URL slugs are strictly unique across all tenants for web routing. |