NFTA Metro · Signage Platform
Database schema — what we store and how it connects
Every screen is a row in boards; departures come from the versioned schedule tables joined with the live Redis snapshot. Click any table to see what it stores and how it links to the rest.
Access & tenancy
Board config
Schedule (GTFS, versioned)
Runtime (Redis)
foreign key
by GTFS id (not a row FK)