wasel - Laravel Schema Designer

Biens_immobiliers

id increments
titre string (1000)
est_vendu boolean
type_id ^FK integer
Ville_id ^FK integer
adresse string
Propreitaire ^FK integer
agent_id ^FK integer
timestamps timestamps
softDeletes softDeletes

TypeBien

id increments
timestamps timestamps
softDeletes softDeletes
nom string

Ville

id increments
timestamps timestamps
softDeletes softDeletes
idR ^FK integer

Region

id increments
timestamps timestamps
softDeletes softDeletes
nom string (1000)

User

id increments
timestamps timestamps
softDeletes softDeletes
Nom string (1000)
prenom string (1000)
numero_telephone string (50)
adresse_email string (100)
password string (1000)

Agent

id increments
timestamps timestamps
softDeletes softDeletes

Courtier

id_courtier increments
timestamps timestamps
softDeletes softDeletes
taux_commission float

visite

id increments
date_heure datetime
bien_id ^FK integer
client_id ^FK integer
agent_id ^FK integer
timestamps timestamps
softDeletes softDeletes

Ventes

id increments
timestamps timestamps
softDeletes softDeletes
bien_immobilier_id ^FK integer
client_id ^FK integer
date_vente date
courtier_id ^FK integer
agent_id ^FK integer
montant float

Attributs_bien

id increments
timestamps timestamps
attribut_id ^FK integer
bien_immobiliere_id ^FK integer
valeur json

Image_bien

id increments
timestamps timestamps
path string
bien_id ^FK integer

Annonce

id increments
timestamps timestamps
softDeletes softDeletes
description string (100)
date_pub datetime
est_accepte boolean
client_id ^FK integer

Propreitaire

id increments
timestamps timestamps

Contact

id increments
timestamps timestamps
message string (300)
client_id ^FK integer

Attributs

id increments
timestamps timestamps
nom string (100)

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