This repository is no longer being supported. Follow this link to the current Marcotti project.
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