This is the SQL implementation of the Football Match Result Database. It currently operates on PostgreSQL and SQLite databases.
This implementation supports a data model for clubs participating in league, knockout, or hybrid (league+knockout) competitions. There are four categories under which the tables are classified:
- Overview: High-level data about the football competition
- Personnel: Participants and officials in the football match
- Match: High-level data about the match
- Match Events: The main events of the football match
The following tables are implemented:
- Competitions
- Teams
- Venues
- VenueHistory
- Players
- PlayerHistory
- Managers
- Referees
- Matches
- Environments
- Lineups
- Goals
- Penalties
- Offenses
- Substitutions
- SwitchPositions
- PenaltyShootouts
- PenShootoutOpeners
The following validation tables are implemented:
- FieldSurfaces
- Phases
- Groups
- Rounds
- KnockoutRounds
- Matchdays
- TimeZones
- WeatherConditions
- Confederations
- Countries
- FieldPositions
- FlankPositions
- Positions (composite)
- LeagueMatches
- GroupMatches
- KnockoutMatches
- HomeTeams
- AwayTeams
- HomeManagers
- AwayManagers
- KickoffWeather
- HalftimeWeather
- FulltimeWeather
- GoalEvents
- GoalStrikes
- PenaltyOutcomes
- Fouls
- Cards
- InSubstitutions
- OutSubstitutions
The following views are implemented:
- TeamsList
- TimeZoneList
- VenueList
- VenueHistoryList
- PositionsList
- PlayersList
- PlayerHistoryList
- ManagersList
- RefereesList
- MatchList
- GroupMatchList
- LeagueMatchList
- KnockoutMatchList
- HomeTeamList
- AwayTeamsList
- KoWxList
- HtWxList
- FtWxList
- EnviroList
- LineupList
- GoalsList
- OwnGoalsList
- PenaltiesList
- CautionsList
- ExpulsionsList
- SubsList
- InSubList
- OutSubList
- SwitchPosList
- ShootoutList
- ShootoutOpenersList