Warehouse
Loading warehouse stats…
Games
15,420
2 min ago
Teams
30
1 hr ago
Pitchers
812
15 min ago
Bullpens
30
5 min ago
Markets
2,340
3 min ago
Predictions
1,284
12 min ago
Players
2,450
2 days ago
Schema Overview
PostgreSQL · pitch_baseball_db
| Table | Columns | Primary Key | Indexes | Partitioned |
|---|---|---|---|---|
| games | 28 | id (uuid) | game_datestatusexternal_id | ✓ |
| teams | 16 | id (uuid) | external_idabbr | — |
| pitchers | 32 | id (uuid) | team_idexternal_id | — |
| bullpens | 22 | id (uuid) | team_idgame_date | — |
| predictions | 24 | id (uuid) | game_idstatus | — |
| markets | 18 | id (uuid) | game_idsportsbook | — |
| players | 20 | id (uuid) | team_idposition | — |