location - Laravel Schema Designer

administrateur

id_admin increments
timestamps timestamps
nom string (100)
email string (100)
login string (100)
mot_de_passe string (255)

proprietaire

id_proprietaire increments
timestamps timestamps
nom string (100)
email string (100)
mot_de_passe string (255)
login string (100)
nickname string (100)
description string (1000)
location string (100)

locataire

id_locataire increments
timestamps timestamps
email string (100)
telephone string (14)
mot_de_passe string (255)
id_proprietaire ^FK integer

propriete

id_propriete increments
timestamps timestamps
nom string (100)
nbrPieces integer
surface string (100)
adresse string (100)
code_postal string (9)
ville string (100)
pays string (100)
description string (1000)
centre string (100)
nbrLot integer
nbrBatiment integer
nbrEtage integer
id_proprietaire ^FK integer
id_type_propriete ^FK integer
eau_chaude boolean
antenne_TV boolean

type_propriete

id increments
type string (255)

type_abonnement

id increments
type_abonnement string (255)

finance

id increments
timestamps timestamps
id_propriete ^FK integer
location string (100)
type_paiement string (100)
autre_type string (100)
date_paiement date
montant integer
statut string (100)
imputer boolean
date_debut date
commentaire string (255)
id_paiement ^FK integer

paiement

id_paiement increments
timestamps timestamps
jour_paiement date
location ^FK integer
frequence ^FK integer
moyen ^FK integer

frequence

id increments
frequence string (255)

moyen

id increments
moyen string (255)

type_paiement

id increments
type string (255)

messages

id_message increments
timestamps timestamps
id_admin ^FK integer
id_proprietaire ^FK integer
id_locataire ^FK integer

location

id_location increments
timestamps timestamps
id_propriete ^FK integer
type_contart string (100)
duree string (100)
date_debut date
loyer_initial integer
charges string (100)
type_charge string (100)
clause boolean
indice string (100)
description string (1000)
clause_part string (100)
garants string (100)
paiement_automatique boolean
echeance_automatique boolean
quittance_automatique boolean
revision_automatique boolean

abonnement

id increments
timestamps timestamps
type ^FK integer

contrat

id increments
timestamps timestamps
type string (255)
duree string (100)
dateDebut date
loyerInitial integer
charges string (255)
typeCharge string (255)
locataire ^FK bigInteger

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