BTB2017-2018 - Laravel Schema Designer

User

id increments
email string (255)
firstname string (255)
lastname string (255)
password string (255)
birthdate date
porfilePicture string
country string (255)
city string (255)
level string (255)
access_token string (255)
timestamps timestamps
softDeletes softDeletes

role

id increments
name string (255)
timestamps string

formations

id increments
title string (255)
desc string (255)
duration time
dateTime datetime
place string (255)
timestamps timestamps
softDeletes softDeletes
category_id ^FK integer
formateur_id ^FK integer

user_formation

id increments
user_id ^FK integer
formation_id ^FK integer
timestamps timestamps

certifications

id increments
timestamps timestamps
titre string (255)
codeCertif string (255)
fee enum
epreuve_duration string
category_id ^FK integer

category

id increments
title string
organisme string
timestamps timestamps

user_certification

id increments
timestamps timestamps
user_id ^FK integer
certification_id ^FK integer

badges

id increments
timestamps timestamps
name string (255)
desc string (255)
picture string

user_badge

id increments
timestamps timestamps
user_id ^FK integer
badge_id ^FK integer

permission

id increments
timestamps timestamps
name string

permission_role

id increments
timestamps timestamps
role_id ^FK integer
permission_id ^FK integer

role_user

id increments
timestamps timestamps
role_id ^FK integer
user_id ^FK integer

messages

id increments
emitDateTime datetime
textMessage string

user_message

id increments
timestamps timestamps
user_id ^FK integer
message_id ^FK integer

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