football

audit_log

audit_id, timestamp, operator_id, run_id, table_name, record_pk, action, column_name, old_value, new_value, reason

0 rows

competition

competition_id, name, slug, type, region, tier, is_active, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

205 rows

data_source

source_id, name, slug, base_url, description, is_active, created_at

11 rows

elo_record

elo_id, team_id, date, rating, k_factor, delta, source_match_id, is_tournament, competition_id, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

Many rows

form_record

form_id, team_id, date, window_matches, pts_avg, gf_avg, ga_avg, xg_for_avg, xg_against_avg, win_pct, draw_pct, loss_pct, competition_id, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

Many rows

h2h_record

h2h_id, team_a_id, team_b_id, date, total_matches, wins_a, wins_b, draws, goals_a, goals_b, last_match_date, last_result, last_match_id, competition_id, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

Many rows

ingestion_run

run_id, source_id, operator_id, target_table, status, raw_file_path, api_endpoint, checksum_md5, rows_inserted, rows_updated, rows_skipped, rows_failed, started_at, ended_at, duration_ms, extra

18 rows

match

match_id, season_id, date, kickoff, home_team_id, away_team_id, home_score, away_score, result, round_stage, matchday, venue, city, country, referee, attendance, is_neutral, is_postponed, is_cancelled, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

101,682 rows

operator

operator_id, name, email, operator_type, description, created_at

3 rows

player

player_id, full_name, display_name, date_of_birth, nationality, position, foot, height_cm, weight_kg, current_team_id, is_active, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

38,279 rows

player_season

Many rows

season

season_id, competition_id, season_name, start_date, end_date, is_active, teams_expected, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

2,084 rows

team

team_id, name, short_name, country_code, continent, team_type, founded_year, is_active, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, source_raw_key

1,299 rows

team_alias

alias_id, team_id, raw_name, source_id, confidence, created_at, updated_at, created_by_run_id, updated_by_run_id, source_raw_key

Many rows