melyve - Laravel Schema Designer

Ecole

id increments
timestamps timestamps
softDeletes softDeletes
NomEcole string (100)

Batiment

id increments
Id_ecole ^FK integer
timestamps timestamps
softDeletes softDeletes
NomBatiment string (100)
NbreSalle integer

Classe

id increments
NomClasse string (10)
Capacite integer
timestamps timestamps
softDeletes softDeletes

Connect

id increments
id_salle ^FK integer
Id_Classe ^FK integer
timestamps timestamps

Salle

id increments
id_batiment ^FK integer
NomSalle string
Capacite integer
timestamps timestamps

Periode

id increments
Libelle string
HBegin time
HEnd time
timestamps timestamps

Student

id increments
Matricule string
FirstName string (100)
LastName string
DateOfBirth datetime
PlaceOfBirth string (100)
Sex string (10)
MobilePhone string (50)
Picture string
timestamps timestamps

Staff

id increments
StaffType ^FK integer
FirstName string (100)
LastName string
DateOfBirth datetime
Sex string (10)
MobilePhone string (50)
HireDate datetime
YearOfService string
Picture string
timestamps timestamps

Role

id increments
Description string
softDeletes softDeletes
timestamps timestamps

Matiere

id increments
Description string
timestamps timestamps

Credentials

IdUser integer
IdTable string
C tinyInteger
R tinyInteger
U tinyInteger
D tinyInteger
timestamps timestamps

Days

id increments
Description string (50)
timestamps timestamps

Schedule

Periode_ID ^FK integer
Planning_ID ^FK integer
timestamps timestamps

Planning

id increments
Staff_Id ^FK integer
Matiere_ID ^FK integer
Connect_ID ^FK integer
Days_ID ^FK integer
PlanDate date
State boolean
timestamps timestamps

Presence

timestamps timestamps
Planning_ID ^FK integer
Student_ID ^FK integer
State boolean

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