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