PolyMusic - Laravel Schema Designer

users

id increments
email string (255)
password string (60)
first_name string (255)
last_name string (255)
birth_date date
phone string (12)
profil_picture string (255)
description text
school_year integer
department_id ^FK integer
level_id ^FK integer
slug string (255)
banned tinyInteger
rememberToken rememberToken
timestamps timestamps

levels

id increments
timestamps timestamps
level integer
name string (255)
infos text
link string (255)

departments

id increments
timestamps timestamps
name string (255)
short_name string (30)

courses

id increments
timestamps timestamps
name string (255)
day tinyInteger
start time
end time
infos text
slug string (255)
instrument_id ^FK integer
article_id ^FK integer
user_id ^FK integer
active tinyInteger

events

id increments
timestamps timestamps
location text
day tinyInteger
start time
end time
infos text
name string (255)
slug string (255)
article_id ^FK integer
date date
user_id ^FK integer
active tinyInteger

bands

id increments
timestamps timestamps
name string (255)
image string (255)
infos text
user_id ^FK integer
validated tinyInteger
slug string (255)
article_id ^FK integer

news

id increments
timestamps timestamps
title string (255)
content text
user_id ^FK integer
active tinyInteger
slug string (255)
published_at date

articles

id increments
timestamps timestamps
title string (255)
subtitle string (255)
content text
user_id ^FK integer
slug string (255)
category_id ^FK integer
validated tinyInteger

course_user

id increments
timestamps timestamps
course_id ^FK integer
user_id ^FK integer
date date
message text
validated tinyInteger
level tinyInteger

band_user

id increments
user_id ^FK integer
band_id ^FK integer
instrument_id ^FK integer

band_event

id increments
band_id ^FK integer
event_id ^FK integer

announcements

id increments
timestamps timestamps
user_id ^FK integer
title string (255)
content text
tags string (255)
slug string (255)
validated tinyInteger
subject string (255)
category_id ^FK integer

comments

id increments
timestamps timestamps
answer_to integer
announcement_id ^FK integer
user_id ^FK integer
content text

blacklist

id increments
timestamps timestamps
ip string (30)
infos string (255)

emails

id increments
timestamps timestamps
sender_email string (255)
subject string (255)
content text
receiver_id ^FK integer
sender_id integer

images

id increments
title string (255)
description string
article_id ^FK integer
name string (255)
timestamps timestamp

instruments

id increments
name string (255)

documents

id increments
timestamps timestamps
title string (255)
name string (255)
user_id ^FK integer
description text
course_id ^FK integer
validated tinyInteger

modifications

id increments
timestamps timestamps
user_id ^FK integer
table string (255)
message string (255)

course_modifications

id increments
timestamps timestamps
author_id ^FK integer
user_id ^FK integer
course_id ^FK integer
message string (255)
value tinyInteger

categories

id increments
timestamps timestamps
name string (255)

notifications

id increments
timestamps timestamps
message string (255)
user_id ^FK integer
new tinyInteger

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