msp - Laravel Schema Designer

type_profils

id increments
libelle string

users

id bigIncrements
email string
firstname string
lastname string
password string
photo string
type_profil_id ^FK integer
is_simple_user tinyInteger
status tinyInteger
timestamps timestamps
softDeletes softDeletes

user_details

id increments
raison_sociale string
address string
nationality string
date_of_birth date
groupe_sanguin string
type_identification string (30)
numero_identification string (30)
numero_carte_etudiant string (20)
ninea string
numero_permis_conduirre string
user_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

secteurs

id increments
libelle string
timestamps timestamps
softDeletes softDeletes

procedures

id increments
secteur_id ^FK integer
libelle string
description text
submission_form_url string
dossier_state_url string
status tinyInteger
timestamps timestamps
softDeletes softDeletes

type_profil_procedures

id increments
type_profil_id ^FK integer
procedure_id ^FK integer
timestamps timestamps

systemes

id increments
libelle string
logo string
base_url string
auth_url string
register_url string
username string
password string
access_token string
status tinyInteger
softDeletes softDeletes
timestamps timestamps

linked_accounts

id increments
login string
last_token string
expired_date string
status tinyInteger
user_id ^FK integer
systeme_id ^FK integer
timestamps timestamps

favorites

id increments
timestamps timestamps
user_id ^FK bigInteger
procedure_id ^FK bigInteger

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