pawa - Laravel Schema Designer

users

id increments
timestamps timestamps
id_type ^FK integer
noms string (255)
email string (255)
password string (255)
salaire float
telephone string (255)
cni string (255)
metier string (255)

building

id increments
timestamps timestamps
libelle string (255)
quartier string (255)
adresse string (255)
description text
nbre_pieces smallInteger
nbre_chambres smallInteger
nbre_salons smallInteger
nbre_douches smallInteger
nbre_cuisines smallInteger
parking boolean
barriere boolean

contrats

id increments
timestamps timestamps
code_contrat string (255)
id_saver ^FK integer
id_locataire ^FK integer
id_building ^FK integer
date_debut datetime
montant_loyer float
nbre_mois integer
reduction float
etat enum

types_user

id increments
timestamps timestamps
libelle string (255)

problemes

id increments
type enum
id_saver ^FK integer
id_validator ^FK integer
timestamps timestamps
id_prestataire ^FK integer
id_contrat ^FK integer
description text

versements_locataire

id increments
timestamps timestamps
motif enum
model string (255)
id_probleme_contrat integer
montant float
annee_mois string (255)
date_versement datetime

depenses

id increments
timestamps timestamps
id_probleme ^FK integer
montant float

versements_salaire

id increments
timestamps timestamps
id_employe ^FK integer
id_saver ^FK integer
montant_prevu float
montant float
date_versement datetime
mois_annee string (255)

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