Statiz
Tables (13)
error_report
- id — BIGINT
- page — VARCHAR(50) — NOT NULL
- tab — VARCHAR(50)
- issue_type — VARCHAR(50) — NOT NULL
- message — TEXT — NOT NULL
- reported_url — VARCHAR(255)
- created_at — TIMESTAMP
hitter_daily_snapshots
- id — BIGINT
- season — INT — NOT NULL
- as_of_date — VARCHAR(8) — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- games — INT
- PA — INT
- AB — INT
- H — INT
- HR — INT
- RBI — INT
- OPS — DECIMAL(6,4)
- OPS_7 — DECIMAL(6,4)
- OPS_14 — DECIMAL(6,4)
hitter_game_logs
- id — BIGINT
- schedule_id — BIGINT — Foreign key → team_schedule.id
- game_id — VARCHAR(50) — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- game_date — VARCHAR(8) — NOT NULL
- PA — INT
- AB — INT
- H — INT
- 2B — INT
- 3B — INT
- HR — INT
- RBI — INT
- BB — INT
- SO — INT
- HBP — INT
- SH — INT
- SF — INT
- R — INT
- SB — INT
- CS — INT
- GDP — INT
- TB — INT
hitter_predictions
- id — BIGINT
- season — INT — NOT NULL
- as_of_date — VARCHAR(8) — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- predicted_hr_final — DECIMAL(8,2)
- predicted_ops_final — DECIMAL(6,4)
- predicted_war_final — DECIMAL(6,3)
- predicted_hits_final — INT
- predicted_rbi_final — INT
- predicted_avg_final — DECIMAL(6,4)
- mvp_probability — DECIMAL(6,4)
- golden_glove_probability — DECIMAL(6,4)
- confidence_level — VARCHAR(20)
- confidence_score — DECIMAL(6,4)
- model_source — VARCHAR(50)
- model_version — VARCHAR(50)
- pa_to_date — DECIMAL(8,2)
hitter_season_totals
- id — BIGINT
- season — INT — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- games — INT
- PA — INT
- AB — INT
- H — INT
- 2B — INT
- 3B — INT
- HR — INT
- RBI — INT
- BB — INT
- SO — INT
- HBP — INT
- SH — INT
- SF — INT
- SB — INT
- CS — INT
- GDP — INT
- AVG — DECIMAL(6,4)
- OBP — DECIMAL(6,4)
- SLG — DECIMAL(6,4)
- OPS — DECIMAL(6,4)
- WAR — DECIMAL(6,3)
pitcher_daily_snapshots
- id — BIGINT
- season — INT — NOT NULL
- as_of_date — VARCHAR(8) — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- role — VARCHAR(30)
- games — INT
- W — INT
- L — INT
- SV — INT
- HLD — INT
- OUTS — INT
- IP — DECIMAL(6,1)
- H — INT
- ER — INT
- BB — INT
- SO — INT
- ERA — DECIMAL(6,3)
- WHIP — DECIMAL(6,3)
- K9 — DECIMAL(6,3)
- BB9 — DECIMAL(6,3)
- KBB — DECIMAL(6,3)
- WAR — DECIMAL(6,3)
pitcher_game_logs
- id — BIGINT
- schedule_id — BIGINT — Foreign key → team_schedule.id
- game_id — VARCHAR(50) — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- game_date — VARCHAR(8) — NOT NULL
- W — INT
- L — INT
- SV — INT
- HLD — INT
- OUTS — INT
- IP — DECIMAL(6,1)
- H — INT
- ER — INT
- BB — INT
- SO — INT
- ERA — DECIMAL(6,3)
- WHIP — DECIMAL(6,3)
- K9 — DECIMAL(6,3)
- BB9 — DECIMAL(6,3)
- KBB — DECIMAL(6,3)
pitcher_predictions
- id — BIGINT
- season — INT — NOT NULL
- as_of_date — VARCHAR(8) — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- role — VARCHAR(30)
- predicted_wins_final — INT
- predicted_losses_final — INT
- predicted_saves_final — INT
- predicted_holds_final — INT
- predicted_ip_final — DECIMAL(6,1)
- predicted_so_final — INT
- predicted_era_final — DECIMAL(6,3)
- predicted_whip_final — DECIMAL(6,3)
- predicted_k9_final — DECIMAL(6,3)
- predicted_kbb_final — DECIMAL(6,3)
- predicted_war_final — DECIMAL(6,3)
- confidence_level — VARCHAR(20)
- confidence_score — DECIMAL(6,4)
- model_source — VARCHAR(50)
pitcher_season_totals
- id — BIGINT
- season — INT — NOT NULL
- player_id — BIGINT — Foreign key → players.id — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- role — VARCHAR(30)
- games — INT
- W — INT
- L — INT
- SV — INT
- HLD — INT
- OUTS — INT
- IP — DECIMAL(6,1)
- H — INT
- ER — INT
- BB — INT
- SO — INT
- ERA — DECIMAL(6,3)
- WHIP — DECIMAL(6,3)
- K9 — DECIMAL(6,3)
- BB9 — DECIMAL(6,3)
- KBB — DECIMAL(6,3)
- WAR — DECIMAL(6,3)
players
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- primary_team_id — BIGINT — Foreign key → teams.id
- player_type — VARCHAR(20)
- bats_throws — VARCHAR(20)
- birth_date — DATE
team_schedule
- id — BIGINT
- season — INT — NOT NULL
- game_date — VARCHAR(8) — NOT NULL
- game_id — VARCHAR(50) — NOT NULL
- away_team_id — BIGINT — Foreign key → teams.id — NOT NULL
- home_team_id — BIGINT — Foreign key → teams.id — NOT NULL
- game_time — VARCHAR(20)
- stadium — VARCHAR(100)
- status — VARCHAR(50)
team_standings
- id — BIGINT
- season — INT — NOT NULL
- as_of_date — VARCHAR(8) — NOT NULL
- team_id — BIGINT — Foreign key → teams.id — NOT NULL
- rank_num — INT — NOT NULL
- games — INT
- wins — INT
- losses — INT
- draws — INT
- win_pct — DECIMAL(6,3)
- gb — DECIMAL(6,1)
- recent_10 — VARCHAR(20)
- streak — VARCHAR(20)
- home_record — VARCHAR(20)
- away_record — VARCHAR(20)
- source — VARCHAR(50)
- source_url — VARCHAR(255)
teams
- id — BIGINT
- name — VARCHAR(50) — NOT NULL