laravel-bde - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
last_name string (255)
password string (60)
level tinyInteger
email string (255)
school_year tinyInteger
department_id ^FK integer
validated boolean
rememberToken rememberToken

departments

id increments
name string (255)
short_name string (10)

teams

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
article text
validated boolean
user_id ^FK integer
slug string (255)

team_user

id increments
timestamps timestamps
user_id ^FK integer
team_id ^FK integer
validated boolean
level tinyInteger

news

id increments
timestamps timestamps
softDeletes softDeletes
published_at timestamps
title string (255)
user_id ^FK integer
content text
team boolean
validated boolean
team_id ^FK integer

events

id increments
timestamps timestamps
softDeletes softDeletes
start timestamp
end timestamp
name string (255)
user_id ^FK integer
validated boolean
article text
team boolean
team_id ^FK integer

contents

id increments
timestamps timestamps
name string (255)
content text
user_id ^FK integer
title string (255)

content_records

id increments
timestamps timestamps
name string (255)
content text
user_id ^FK integer
title string (255)

notifications

id increments
timestamps timestamps
content string
link string (255)
user_id ^FK integer
seen tinyInteger

pictures

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
legend text
user_id ^FK integer
path string (255)
team_id ^FK integer
event_id ^FK integer
news_id ^FK integer

tags

id increments
name string (255)
uses integer

picture_tag

id increments
picture_id ^FK integer
tag_id ^FK integer

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