JogosHoje - Laravel Schema Designer

countries

id increments
name string (90)
slug char (120)
code char (2)
primary_league_id integer
visible boolean

leagues

id increments
name string (90)
slug char (120)
country_id ^FK integer
is_cup boolean
api_id integer

seasons

id increments
season smallInteger

teams

id increments
name char (120)
slug char (120)
code char (3)
country_id ^FK integer
national boolean
api_id integer

standings

id increments
team_id ^FK integer
league_id ^FK integer
season_id ^FK integer
rank smallInteger
points smallInteger
goals_diff tinyInteger
form char (5)
status char (10)
played tinyInteger
wins smallInteger
draws smallInteger
loses smallInteger
goals_for smallInteger
goals_against smallInteger
round_id ^FK integer
last_updated timestamp

fixtures

id increments
team_home ^FK integer
team_away ^FK integer
api_id integer
timestamp timestamps
status char (5)
league_id ^FK integer
round_id ^FK integer
is_live boolean
goals_home smallInteger
goals_away smallInteger
penalty_home smallInteger
penalty_away smallInteger
last_updated timestamps

fixture_events

id increments
fixture_id ^FK integer
type char (5)
time smallInteger
team_id ^FK integer
player char (120)
assist char (120)
description string (255)

league_participations

id increments
team_id ^FK integer
league_id ^FK integer

rounds

id increments
name char (120)
slug char (90)
league_id ^FK integer
season_id ^FK integer

pages

id increments
timestamps timestamps
title string (255)
content text

seo_data

id increments
pattern string (255)
title string (60)
keywords string (65)
description string (170)
image text

favorite_countries

id increments
country_id ^FK integer
order smallInteger

favorite_leagues

id increments
league_id ^FK integer
order smallInteger

affiliations

id increments

users

id increments

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