Football

National Football Championship. Information on a single season of one team. Each game lasts exactly 90 minutes.

Tables

Players: 

Players (player_id, first_name, last_name, nickname, citizenship, dob, role)

player_id -uniform number,

nickname - name on the uniform,

citizenship (NULL for native players),

dob – date of birth,

role - position;

Games:

Games(game_id, team, city, goals, game_date, own)

team - opposing team,

city -city where the match took place (NULL if it was a home game),

goals -goals scored by the opponent, including own goals shot by own players (NULL if not scored),

game_date - match date/time,

own - own goals by opposing team (null if there were none);

Participation in games:

Lineups(start, game_id, player_id, time_in, goals, cards)

start - ‘B’ - the player was in the starting lineup, ‘S’ - he started the match on the bench;

time_in - playing time in minutes (NULL if the player did not enter the game);

goals - the number of goals the player scored in the match (NULL if he didn’t score any goals);

cards – penalty cards: ‘Y’ (yellow), ‘Y2’ (two yellow cards), ‘R’ (direct red), ‘YR’ (yellow+direct red), NULL (no cards shown).