Magazins - Laravel Schema Designer

categories

id increments
timestamps timestamps
Desingnation string (100)

sous_categories

id increments
timestamps timestamps
designation string (100)
categories_id ^FK integer

articles

id increments
timestamps timestamps
references string (100)
designation string (100)
description text
prix_vente float
qte_stock float
qte_alert float
photo string
sous_categories_id ^FK integer

commendes

id increments
timestamps timestamps
references string (100)
date_commende date
commentaire text
clients_id ^FK integer

clients

id increments
timestamps timestamps
fullname string (100)
tel string (100)
e_mail string (100)
adresse text
villes_id ^FK integer

avoirs

id increments
timestamps timestamps
references string (100)
date_avoir date
commentaire text
commendes_id ^FK integer

villes

id increments
timestamps timestamps
designation string (100)
code_postal string (100)

relation

id increments
timestamps timestamps
articles_id ^FK integer
commendes_id ^FK integer

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