Designing a Sports Data Schema: Fixtures, Markets, Outcomes and Odds in PostgreSQL
The schema you regret in month three
Almost every sports app starts the same way. Someone creates a table:
sql
CREATE TABLE matches (
id serial PRIMARY KEY,
home_team text,
away_team text,
hom
bettechmagnetics.hashnode.dev20 min read