stackMatch - Laravel Schema Designer

users

id increments
team_id ^FK integer
timestamps timestamps

teams

id increments
logo string
name string (100)
create_by ^FK integer
number_of_footballers integer
tournament_points integer
played_matches integer
completed_tournaments integer
timestamps timestamps

tournaments

id increments
name string (255)
dateDebut date
dateFin date
registerDateLimit date
promoter ^FK integer
timestamps timestamps

matchs

id increments
start_dateTime datetime
end_dateTime datetime
first_team ^FK integer
second_team ^FK integer
first_team_score integer
second_team_score integer
tournament_id ^FK integer
winner string (100)
status integer
timestamps timestamps

invitations

id increments
object string (100)
object_id integer
email string (100)
token string (16)
accepted boolean
accepted_at timestamp
timestamps timestamps

tournament_competitors

id increments
tournament_id ^FK integer
confirmed boolean
timestamps timestamps
team_id ^FK integer

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