football - Laravel Schema Designer

teams

id increments
name string (100)
description text
logo string (200)
league_id string
timestamps timestamps
softDeletes softDeletes

players

id increments
name string (100)
image string (200)
team_id string
role integer
softDeletes softDeletes
timestamps timestamps

leagues

id increments
name string (100)
image string (200)
description text
timestamps timestamps
softDeletes softDeletes

matches

id increments
team1_id integer
team2_id integer
score_club1 integer
score_club2 integer
start_time datetime
place string
end_time datetime
timestamps timestamps
softDeletes softDeletes

seasons

id increments
name string (100)
current integer
timestamps timestamps
softDeletes softDeletes

league_matches

id increments
league_id integer
season_id integer
match_id integer
timestamps timestamps
softDeletes softDeletes

rank

id increments
season_id integer
team_id integer
score integer
number integer
timestamps timestamps
softDeletes softDeletes

comments

id increments
user_id string
status integer
content string
commentable_id integer
commentable_type string
softDeletes softDeletes
timestamps timestamps

categories

id increments
name string
slug string
description text
softDeletes softDeletes
timestamps timestamps

user_bets

id increments
user_id integer
match_id integer
point integer
team_id integer
result integer
softDeletes softDeletes
timestamps timestamps

users

id increments
name string (100)
avatar string (200)
email string (100)
password string (60)
role integer
point integer
timestamps timestamps
softDeletes softDeletes

social_accounts

id increments
user_id integer
type string
social_user_id integer
timestamps timestamps
softDeletes softDeletes

posts

id increments
user_id integer
category_id integer
league_id integer
slug string
title string
content text
excerpt string
published_at datetime
timestamps timestamps
softDeletes softDeletes

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