Hadeca7 - Laravel Schema Designer

roles

id increments
name string
display_name string (255)
description string
timestamps timestamps

users

id increments
name string (100)
firstname string (100)
lastname string (100)
email string
password string
zip_code string (10)
address string (255)
city string (100)
phone string (20)
remember_token string (100)
timestamps timestamps

permissions

id increments
name string
display_name string
description text
timestamps timestamps

role_user

role_id ^FK integer
user_id ^FK integer

permission_role

role_id ^FK integer
permission_id ^FK integer

pages

id increments
slug string (100)
label string (80)
content text
published boolean
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps

contracts

id increments
user_id ^FK integer
start_date date
end_date date
type string (100)
timestamps timestamps

pages_history

id increments
page_id ^FK integer
content text
created_at timestamp

medias

id increments
file_name string (80)
mime_type string (50)
file_weight integer
picture_width integer
picture_height integer
created_at timestamp
created_by ^FK integer

menus

id increments
parent_id ^FK integer
slug string (100)
label string (50)
timestamps timestamps

actualities

id increments
slug string (100)
label string (100)
content text
published boolean
in_slider boolean
picture_name string (80)
created_by ^FK integer
upated_by ^FK integer
timestamps timestamps

actualities_history

id increments
actuality_id ^FK integer
content text
created_at timestamp

contacts

id increments
type_search integer
type_person integer
civility integer
firstname string (100)
lastname string (100)
email string (255)
society string (255)
phone string (100)
content text
seen boolean
timestamps timestamps

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