lsg - Laravel Schema Designer

student

id increments
timestamps timestamps
profile ^FK integer
mother_id ^FK integer
father_id ^FK integer

teacher

id increments
timestamps timestamps
profile ^FK integer
department_id ^FK integer

club

id increments
timestamps timestamps
nom string
responsable_id ^FK integer

class_room

id increments
timestamps timestamps

office

id increments
timestamps timestamps

administrator

id increments
timestamps timestamps

book

id increments
timestamps timestamps
isbn10 string
isbn13 string
title string
auther string

book_copy

id increments
timestamps timestamps
book_id ^FK integer

borrowing

id increments
timestamps timestamps
book_copy_id ^FK integer
borrowedBy ^FK integer
biblio_id ^FK integer

user

id increments
timestamps timestamps
email string
password string
first_name string
last_name string
digicode string
activated boolean
activation_code string
activated_at timestamps
last_login timestamps
pseudo string
reset_password_code string

calendar

id increments
timestamps timestamps
year integer
comment string

event

timestamps timestamps
calendar_id ^FK integer
id increments

dorm

id increments
timestamps timestamps

mail_box

id increments
timestamps timestamps

biblio

id increments
timestamps timestamps

building

id increments
timestamps timestamps

department

id increments
timestamps timestamps
name string

staff

id increments
timestamps timestamps
profile ^FK integer

vehicle

id increments
timestamps timestamps
user_id ^FK integer
authorisation_id ^FK integer

restaurant

id increments
timestamps timestamps

menu

id increments
timestamps timestamps

absence

id increments
timestamps timestamps
user_id ^FK integer

grade

id increments
timestamps timestamps
student_id ^FK integer
assessment_id ^FK integer
value float

delayed

id increments
timestamps timestamps
user_id ^FK integer

scientific_board

id increments
timestamps timestamps
teacher_id ^FK integer

server

id increments
timestamps timestamps

switch

id increments
timestamps timestamps

hotspot

id increments
timestamps timestamps

parent

id increments
timestamps timestamps
first_name string
last_name string
telephone string
email string
address string

course

id increments
timestamps timestamps
title string

lesson

id increments
timestamps timestamps
course_id ^FK integer
event_id ^FK integer
title string

assessment

id increments
timestamps timestamps
teacher_id ^FK integer
course_id ^FK integer
event_id ^FK integer
coef float

quiz

id increments
timestamps timestamps
lesson_id ^FK integer

forum_post

timestamps timestamps
id increments
course_id ^FK integer

user_progress

id increments
timestamps timestamps
student_id ^FK integer

quiz_qr

id increments
timestamps timestamps
quiz_id ^FK integer

forum_msg

id increments
timestamps timestamps
post_id ^FK integer
user_id ^FK integer

authorisation

id increments
timestamps timestamps

membre_club

id increments
timestamps timestamps

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