KaliSchool - Laravel Schema Designer

ANNEE_SCOLAIRE

id bigIncrements
timestamps timestamps
softDeletes softDeletes
annee date
date_rentree date
libelle_annee string (100)

NIVEAU

id bigIncrements
timestamps timestamps
softDeletes softDeletes
libelle_niveau string (100)
cycle_id ^FK bigInteger
scolarite bigInteger
frais_inscription bigInteger

CLASSE

id bigIncrements
timestamps timestamps
softDeletes softDeletes
libelle_classe string (100)
niveau_id ^FK bigInteger
batiment_id ^FK bigInteger

student

id bigIncrements
timestamps timestamps
softDeletes softDeletes
fisrt_name string (125)
last_name string (125)
registration_number string (125)
parent_id ^FK integer
classe_id ^FK bigInteger
photo string (255)
admis boolean
phone string (125)

PARENT

id bigIncrements
timestamps timestamps
softDeletes softDeletes
full_name string (100)
parent_phone string (125)

ENSEIGNANT

id bigIncrements
timestamps timestamps
softDeletes softDeletes
nom_enseignant string (125)
prenom_ensignant string (125)
tel_enseignant string (125)

MATIERE

id increments
timestamps timestamps
softDeletes softDeletes
code_matiere string (125)
libelle_matiere string (125)

EVALUATION

id increments
timestamps timestamps
softDeletes softDeletes
matiere_id ^FK bigInteger
note integer
date_evaluation date

EMPLOISTEMPS

id increments
timestamps timestamps
softDeletes softDeletes
classe_id ^FK bigInteger
libelle_emplois_temps string (125)
fichier_emplois_temps text

PAIEMENT_SCOLARITE

id bigIncrements
timestamps timestamps
softDeletes softDeletes
montant bigInteger
classe_id ^FK bigInteger
mois string (20)
date_paiement datetime
eleve_id ^FK bigInteger

CYCLE

id bigIncrements
timestamps timestamps
softDeletes softDeletes
libelle_cycle string (125)
anneeScolaire_id ^FK bigInteger

BATIMENT

id bigIncrements
timestamps timestamps
softDeletes softDeletes
libelle_batiment string (125)

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