Org DB — PostgreSQL

Each organization has its own PostgreSQL database containing all sports data. For the beta, The Farm League's data lives in the existing RDS instance.

Schema

The org database has 63 tables covering teams, players, games, scheduling, tournaments, chat, umpires, registration, facilities, and more. The full schema is defined in youth-sports-manager/shared/schema.ts.

Page Status

Ready for content. This page will document the key org DB tables and their relationships.