telesport - Laravel Schema Designer

users

id increments
role_id ^FK integer
email string (50)
first_name string (50)
last_name string (50)
birthdate timestamp
description text
facebook_profile string (255)
googleplus_profile string (255)
instagram_profile string (255)
created_at timestamp
updated_at timestamp
deleted_at timestamp

roles

id increments
name string (50)

posts

id increments
user_id ^FK integer
title string (255)
summary text
content text
slug string (255)
cover string (255)
video string (255)
published boolean
draft boolean

tags

id increments
name string (50)
description string (255)
published boolean

post_tag

id increments
post_id ^FK integer
tag_id ^FK integer

categories

id increments
name string (50)
description text
cover string (255)
color string
published boolean

user_category

id increments
user_id ^FK integer
category_id ^FK integer

leagues

id increments
name string (50)
logo string (255)
cover string (255)

teams

id increments
league_id ^FK integer
name string (50)
logo string (255)
cover string (255)

user_team

id increments
user_id ^FK integer
team_id ^FK integer

post_category

id increments
post_id ^FK integer
category_id ^FK integer

matches

id increments
home_team_id ^FK integer
away_team_id ^FK integer
live boolean
start_at timestamp
score string

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