portofolio - Laravel Schema Designer

users

id increments
timestamps timestamps
pseudo string (30)
role_id ^FK integer
email string (60)
password string (60)
seen boolean
actif boolean
remember_token string (100)
nom string (30)
prenom string (30)
avatar string (150)
confirmed boolean
confirmed_code string (255)

roles

id increments
timestamps timestamps
title string (30)
slug string (10)
create boolean
modif boolean
delete boolean
valid_edition boolean
user_gestion boolean
message_gest boolean

posts

id increments
timestamps timestamps
users_id ^FK integer
title string (60)
seen boolean
active boolean
summary string
content text
image string
slug string (30)

posts_tag

id increments
timestamps timestamps
tag_id ^FK integer
posts_id ^FK integer

tags

id increments
timestamps timestamps
title string

works

id increments
timestamps timestamps
users_id ^FK integer
title string (60)
slug string (30)
seen boolean
active boolean
summary string
content text
image string

categories

id increments
timestamps timestamps
title string

images

id increments
timestamps timestamps
title string (60)
slug string (30)
url string
width smallInteger
height smallInteger

works_cat

id increments
timestamps timestamps
works_id ^FK integer
cat_id ^FK integer

img_cat

id increments
timestamps timestamps
img_id ^FK integer
cat_id ^FK integer

woks_gal

id increments
timestamps timestamps
works_id ^FK integer
img_id ^FK integer

posts_gal

id increments
timestamps timestamps
posts_id ^FK integer
img_id ^FK integer

config

id increments
timestamps timestamps

contacts

id increments
timestamps timestamps
name string
email string
content text
seen boolean

password_resets

id increments
timestamps timestamps
email string
token string

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