Partners - Laravel Schema Designer

users

id increments
gender string (3)
firstname string (50)
lastname string (50)
function string (50)
email string (255)
phone string (10)
partners_id ^FK integer
password string (255)
remember_token string (100)
timestamps timestamps

partners

id increments
type string (50)
name string (50)
address string (255)
cp string (5)
city string (255)
phone string (10)
order_prefix string (255)
ps_name string (255)
parent_id ^FK integer
is_store boolean
timestamps timestamps

notifications

id string (36)
type string (255)
notifiable_id ^FK integer
notifiable_type string (255)
data text
read_at timestamp
timestamps timestamps

orders

id increments
ref string (255)
partner_id ^FK integer
cart_id ^FK integer
current_state ^FK integer
total_nb_products integer
total_products_ht decimal (10,2)
total_taxes decimal (10,2)
valid boolean
total_products_volume decimal
total_products_poids decimal
timestamps timestamps

orders_states

id increments
name string (255)
display_name string (255)
description string (255)
invoice boolean
order boolean
send_email boolean
email_template string (255)
timestamps timestamps

orders_details

id increments
order_id ^FK integer
product_id ^FK integer
product_name string (255)
product_qty integer
product_price_ht decimal (10,2)
product_price_wt decimal (10,2)
total_volume decimal
total_poids decimal
total_price_ht decimal (10,2)
total_price_wt decimal (10,2)

permissions

id increments
name string (255)
display_name string (255)
description string (255)
timestamps timestamps

roles

id increments
name string (255)
display_name string (255)
description string (255)
timestamps timestamps

shopping_cart

id integer
identifier string (255)
instance string (255)
content text
timestamps timestamps

vouchers

id increments
code string (255)
order_id ^FK integer
timestamps timestamps

products

id increments
reference string (255)
name string (255)
description string (255)
price_ht decimal (10,2)
active boolean
poids decimal
volume decimal
timestamps timestamps

invoices

id increments
ref string (255)
current_state ^FK integer
total_nb_order integer
total_orders_ht decimal (10,2)
total_orders_ttc decimal (10,2)
timestamps timestamps

order_invoice

id increments
order_id ^FK integer
invoice_id ^FK integer

payments

id increments
token string (255)
currency string (3)
amount bigInteger
description string (255)
invoice_id ^FK integer
timestamps timestamps

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