monLoge - Laravel Schema Designer

utilisateurs

id increments
timestamps timestamps
softDeletes softDeletes
nom string (255)
adresse string (255)
email string (255)
login string (255)
password string (255)
sexe string (255)
telephone string (255)
typeUser_id ^FK integer
statut string (255)
slug string (255)

typeUsers

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)

biens

id increments
timestamps timestamps
softDeletes softDeletes
proprietaire_id ^FK integer
nom string (255)
typemouvement string (255)
nbrchambre string (255)
surface string (255)
adresse string (255)
codepostal string
ville string (255)
pays string (255)
nbrbatiment string (255)
nbretage string (255)
nbrescalier string (255)
numeroporte string (255)
zoneStationnement string (255)
ungarage string (255)
unecave string
internet string (255)
dep_tvecranplat string (255)
dep_lingemaison string (255)
dep_lavevaiselle string (255)
pc_gardiennage string (255)
pc_interphone string (255)
pc_ascenseur string (255)
pc_vide_ordure string (255)
pc_espace_vert string (255)
pc_chauffage_collective string
pc_eau_chaude_collective string
pc_antennetv_collective string (255)
exist_balcon string (255)
exist_cheminee string (255)
exist_salle_manger string (255)
exist_proxi_education string (255)
exist_sous_sol string (255)
exist_proxi_centre_sante string (255)
exist_proxi_restaurant string (255)
anneeconstruction string (255)
nbr_salle_bain string
img1 string (255)
img2 string (255)
img3 string (255)
img4 string (255)
img5 string
img6 string (255)
img7 string (255)
typeBien_id ^FK integer
statut string (255)
slug string (255)

typeBiens

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)

locations

id increments
timestamps timestamps
softDeletes softDeletes
locataire_id ^FK integer
proprietaire_id ^FK integer
contrat_id ^FK integer
slug string (255)

contrats

id increments
timestamps timestamps
softDeletes softDeletes
duree string (255)
dateDedut string (255)
montantLoyer string (255)
charge string (255)
typecharge_id ^FK integer
periode_paiement string (255)
jourpaiement string (255)
typePaiement_id ^FK integer
clause_revision_loyer string (255)
indice_reference string (255)
description_bail string (255)
clauseparticuliere string (255)
garantsolidaire string (255)
aut_paiement string (255)
aut_avis_echeance string (255)
aut_quittance string (255)
typeContrat_id ^FK integer
statut string (255)
slug string (255)
proprietaire_id ^FK integer
locataire_id ^FK integer
location_id ^FK integer

typeContrats

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)
slug string

typeCharge

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)
slug string (255)

finances

id increments
timestamps timestamps
softDeletes softDeletes
proprietaire_id ^FK integer
bien_id ^FK integer
typePaiement_id ^FK integer
autre_typepaiement string (255)
datepaiement string (255)
montant string (255)
statut string (255)
periode string (255)
commentaire string (255)
frequence string (255)
typeFinance_id ^FK integer
slug string

typePaiement

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)
slug string (255)

typeFinances

id increments
timestamps timestamps
softDeletes softDeletes
libelle string (255)
slug string (255)

messages

id increments
timestamps timestamps
softDeletes softDeletes
recepteur_id ^FK integer
emetteur_id ^FK integer
contenue string (255)
statut string (255)
slug string (255)

typeAbonnements

id increments
timestamps timestamps
softDeletes softDeletes
nom string (255)
montant string
description string (255)
duree string (255)
slug string (255)

abonnees

id increments
timestamps timestamps
softDeletes softDeletes
proprietaire_id ^FK integer
typeAbonnement_id ^FK integer
statut string (255)
slug string (255)

pays

id increments
timestamps timestamps
softDeletes softDeletes
nom string (255)

regions

id increments
timestamps timestamps
softDeletes softDeletes
nom string (255)
pay_id ^FK integer

villes

id increments
timestamps timestamps
softDeletes softDeletes
nom string (255)
pay_id ^FK integer
region_id ^FK integer

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