Série-All - Laravel Schema Designer

users

id increments
username string
user_url string
email string
password string
role tinyInteger
suspended boolean
activated boolean
edito text
antispoiler boolean
website string
twitter string
facebook string
ip string
rememberToken rememberToken
timestamps timestamps

shows

id increments
thetvdb_id integer
show_url string
name string
name_fr string
synopsis text
synopsis_fr text
format integer
annee integer
encours boolean
diffusion_us date
diffusion_fr date
moyenne float
moyenne_redac float
nbnotes integer
taux_erectile integer
avis_rentree text
timestamps timestamps

seasons

id increments
thetvdb_id integer
name smallInteger
ba text
moyenne float
nbnotes integer
show_id ^FK integer
timestamps timestamps

episodes

id increments
thetvdb_id integer
numero smallInteger
name string
name_fr string
resume text
resume_fr text
particularite text
diffusion_us date
diffusion_fr date
ba text
moyenne float
nbnotes integer
season_id ^FK integer
timestamps timestamps

artists

id increments
name string
artist_url string
timestamps timestamps

artistables

artist_id ^FK integer
artistable_id integer
artistable_type string
profession enum
role string

channels

id increments
name string
channel_url string
timestamps timestamps

channel_show

channel_id ^FK integer
show_id ^FK integer

nationalities

id increments
name string
nationality_url string
timestamps timestamps

nationality_show

nationality_id ^FK integer
show_id ^FK integer

genres

id increments
name string
genre_url string
timestamps timestamps

genre_show

genre_id ^FK integer
show_id ^FK integer

temps

id increments
key string
value text
timestamps timestamps

user_activations

user_id integer
token string
timestamps timestamps

comments

id increments
left integer
right integer
message text
thumb string
spoiler boolean
user_id ^FK integer
parent_id ^FK integer
commentable_id integer
commentable_type integer
timestamps timestamps

show_user

show_id ^FK integer
user_id ^FK integer
state tinyInteger
message text

slogans

id increments
message text
source string
url string
timestamps timestamps

episode_user

episode_id ^FK integer
user_id ^FK integer
rate smallInteger

articles

id increments
timestamps timestamps
name string
article_url string
intro text
content text
image string
source string
state tinyInteger
frontpage boolean
category_id ^FK integer

categories

id increments
timestamps timestamps

article_user

article_id ^FK integer
user_id ^FK integer

articlables

article_id ^FK integer
articlable_id integer
articlable_type string

polls

id increments
timestamps timestamps
name string
poll_url string

questions

id increments
timestamps timestamps
name string
poll_id ^FK integer

answers

id increments
timestamps timestamps
name string
question_id ^FK integer

poll_user

poll_id ^FK integer
user_id ^FK integer

logs

id increments
list_log_id ^FK integer
message text
timestamps timestamps

list_logs

id increments
job string
object string
object_id integer
user_id ^FK integer
timestamps timestamps

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