Schema - public (tables)

Tables - 109
Name OID Size Estimated rows Primary key Columns Indexes Comment
addresses 24692 96.0 KB 0 17 5
affiliation_phases 24701 24.0 KB 55 7 1
affiliations 24707 72.0 KB 29 4 4
affiliations_documents 24711 72.0 KB 1234 2 0
affiliations_events 24714 488.0 KB 13052 2 0
affiliations_media 24717 0 bytes 0 2 0
american_football_action_participants 24722 120.0 KB 213 9 5
american_football_action_plays 24728 136.0 KB 179 7 5
american_football_defensive_stats 24737 104.0 KB 570 13 1
american_football_down_progress_stats 24746 32.0 KB 26 11 1
american_football_event_states 24755 88.0 KB 193 14 3
american_football_fumbles_stats 24761 32.0 KB 91 14 1
american_football_offensive_stats 24770 32.0 KB 26 6 1
american_football_passing_stats 24779 64.0 KB 227 20 1
american_football_penalties_stats 24788 24.0 KB 26 4 1
american_football_rushing_stats 24794 32.0 KB 124 7 1
american_football_sacks_against_stats 24803 24.0 KB 56 3 1
american_football_scoring_stats 24809 96.0 KB 640 18 1
american_football_special_teams_stats 24818 32.0 KB 110 30 1
attachments 178391 73.883 MB 0 2 0
baseball_action_contact_details 24827 16.0 KB 0 8 1
baseball_action_pitches 24836 40.0 KB 0 13 4
baseball_action_plays 24845 64.0 KB 17 14 3
baseball_action_substitutions 24854 8.0 KB 0 12 1
baseball_defensive_group 24860 8.0 KB 0 1 1
baseball_defensive_players 24866 8.0 KB 0 4 1
baseball_defensive_stats 24872 160.0 KB 1528 10 1
baseball_event_states 24881 56.0 KB 17 21 3
baseball_offensive_stats 24887 256.0 KB 1528 34 1
baseball_pitching_stats 24896 160.0 KB 752 30 1
basketball_defensive_stats 24905 24.0 KB 128 5 1
basketball_event_states 24911 16.0 KB 0 8 2
basketball_offensive_stats 24917 64.0 KB 128 27 1
basketball_rebounding_stats 24926 32.0 KB 128 9 1
basketball_team_stats 24935 8.0 KB 0 5 1
bookmakers 24941 8.0 KB 0 4 1
core_person_stats 24947 144.0 KB 1582 7 1
core_stats 24953 16.0 KB 0 7 1
db_info 24960 8.0 KB 0 1 1
display_names 24966 488.0 KB 3958 13 1
document_classes 24975 40.0 KB 6 2 2
document_contents 24981 136.0 KB 414 4 2
document_fixtures 24990 72.0 KB 12 5 4
document_fixtures_events 24996 736.0 KB 4428 5 4
document_package_entry 25002 8.0 KB 0 6 1
document_packages 25008 8.0 KB 0 4 1
documents 25014 376.0 KB 414 12 8
documents_media 25023 8.0 KB 0 4 1
events 25029 992.0 KB 4350 10 4
events_documents 25036 312.0 KB 0 2 0
events_media 25039 0 bytes 0 2 0
events_sub_seasons 25042 184.0 KB 0 2 0
ice_hockey_action_participants 25047 24.0 KB 138 5 1
ice_hockey_action_plays 25053 32.0 KB 51 6 1
ice_hockey_defensive_stats 25062 32.0 KB 46 19 1
ice_hockey_event_states 25071 24.0 KB 51 8 1
ice_hockey_offensive_stats 25077 120.0 KB 839 23 1
ice_hockey_player_stats 25086 96.0 KB 817 2 1
injury_phases 25092 336.0 KB 771 11 6
key_aliases 25101 16.0 KB 0 3 2
key_roots 25107 16.0 KB 0 2 2
latest_revisions 25113 112.0 KB 295 3 3
locations 25119 40.0 KB 0 5 2
media 25125 8.0 KB 0 10 1
media_captions 25131 8.0 KB 0 7 1
media_contents 25137 16.0 KB 0 10 1
media_keywords 25146 8.0 KB 0 3 1
motor_racing_event_states 25152 16.0 KB 0 9 2
motor_racing_qualifying_stats 25158 16.0 KB 0 8 1
motor_racing_race_stats 25167 16.0 KB 0 27 1
outcome_totals 25176 16.0 KB 0 19 1
participants_events 25185 1.836 MB 8700 8 6
periods 25191 112.0 KB 548 4 2
person_event_metadata 25197 992.0 KB 4002 11 7
person_phases 25203 48.0 KB 0 21 6
persons 25209 664.0 KB 3937 10 3
persons_documents 25213 0 bytes 0 2 0
persons_media 25216 0 bytes 0 2 0
positions 25221 56.0 KB 73 3 3
publishers 25227 40.0 KB 1 3 2
roles 25233 16.0 KB 0 4 2
seasons 25239 72.0 KB 4 6 4
sites 25245 32.0 KB 0 4 4
soccer_defensive_stats 25251 16.0 KB 0 13 1
soccer_event_states 25260 24.0 KB 0 10 2
soccer_foul_stats 25269 16.0 KB 0 8 1
soccer_offensive_stats 25278 16.0 KB 0 26 1
sportsdb_table 178383 8.0 KB 0 2 0
standing_subgroups 25287 8.0 KB 0 3 1
standings 25293 16.0 KB 0 13 1
stats 25302 3.031 MB 9398 8 8
sub_periods 25308 16.0 KB 0 4 2
sub_seasons 25314 72.0 KB 4 6 4
team_american_football_stats 25320 32.0 KB 26 6 1
team_phases 25329 80.0 KB 368 9 1
teams 25335 24.0 KB 128 4 1
teams_documents 25339 40.0 KB 0 2 0
teams_media 25342 0 bytes 0 2 0
tennis_action_points 25347 8.0 KB 0 4 1
tennis_action_volleys 25353 16.0 KB 0 8 1
tennis_event_states 25362 24.0 KB 0 12 2
tennis_return_stats 25371 16.0 KB 0 13 1
tennis_service_stats 25380 16.0 KB 0 16 1
wagering_moneylines 25389 16.0 KB 0 12 1
wagering_odds_lines 25398 16.0 KB 0 13 1
wagering_runlines 25407 16.0 KB 0 13 1
wagering_straight_spread_lines 25416 16.0 KB 0 12 1
wagering_total_score_lines 25425 16.0 KB 0 14 1
weather_conditions 25434 24.0 KB 0 9 2