plaer - Laravel Schema Designer

Player

id increments
timestamps timestamps
Add new column

Team

id increments
timestamps timestamps
Add new column

TeamPlayer

team_id ^FK integer
id increments
player_id ^FK integer
timestamps timestamps
date_start date
date_finish string
Add new column

Match

id increments
timestamps timestamps
tournament_season_id tinyInteger
home_id tinyInteger
away_id tinyInteger
Add new column

Tournament

id increments
timestamps timestamps
Add new column

TournamentSeason

id increments
season_id integer
tournament_id tinyInteger
start_date date
finish_date date
timestamps timestamps
Add new column

MatchPlayer

id increments
match_id integer
team_id ^FK integer
player_id ^FK integer
timestamps timestamps
Add new column

Season

id increments
timestamps timestamps
Add new column

MatchLogs

id increments
match_id ^FK integer
team_id ^FK integer
event tinyInteger
time tinyInteger
player_1_id ^FK integer
player_2_id ^FK integer
timestamps timestamps
Add new column

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01