polemetropolitain - Laravel Schema Designer

users

id increments
timestamps timestamps
email_verified_at timestamp
softDeletes softDeletes
password string (100)
firstname string (100)
gender enum
lastname string (255)
address text
sub_address text
zip_code string (15)
city string (100)
cedex string (15)
phone_number string (20)
picture ^FK integer
email string (100)
role string (255)
url text
job string (255)
description text
locale string (255)
rememberToken rememberToken
organism string (255)
stopMail boolean

groups

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

files

id increments
timestamps timestamps
name string
path text
extension string (16)
softDeletes softDeletes
content longText
preview text
keywords text
author ^FK integer
copyright text

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
type enum

folders

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
description text
thumbnail ^FK integer
dependency ^FK integer
shared boolean
access boolean

events

id increments
timestamps timestamps
softDeletes softDeletes
title string (255)
start datetime
end datetime
place text
importance integer

groups_users

user_id ^FK integer
group_id ^FK integer

events_groups

event_id ^FK integer
group_id ^FK integer
sent boolean

events_users

user_id ^FK integer
event_id ^FK integer
presence boolean

categories_files

category_id ^FK integer
file_id ^FK integer

files_folders

file_id ^FK integer
folder_id ^FK integer

folders_groups

folder_id ^FK integer
group_id ^FK integer
permissions string (10)

folders_users

folder_id ^FK integer
user_id ^FK integer
permissions string (10)

categories_events

category_id ^FK integer
event_id ^FK integer

files_groups

file_id ^FK integer
group_id ^FK integer
sent datetime

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