db_sisporta - Laravel Schema Designer

products

id increments
name string
description text
image string
parent_id integer
softDeletes softDeletes
timestamps timestamps

resellers

id increments
name string
email string
address text
fiscal_number string
phone string
phone2 string
fax string
image string
softDeletes softDeletes
timestamps timestamps

product_price

product_id ^FK integer
reseller_id ^FK integer
price decimal (8,2)
timestamps timestamps

categories

id increments
name string
softDeletes softDeletes
timestamps timestamps

product_category

product_id ^FK integer
category_id ^FK integer
timestamps timestamps

simulations

id increments
user_id integer
category_id ^FK integer
description string
lintel integer
height integer
width integer
space_left integer
space_right integer
total_area decimal (8,2)
subtotal decimal
client_name string
client_address text
client_phone string
client_email string
softDeletes softDeletes
timestamps timestamps

simulation_product

id increments
simulation_id ^FK integer
product_id ^FK integer
quantity integer
price decimal
discount integer
final_price decimal
timestamps timestamps

orders

id increments
simulation_id ^FK integer
notes text
softDeletes softDeletes
timestamps timestamps

order_product

id increments
order_id ^FK integer
product_id integer
quantity integer
price decimal
discount integer
final_price decimal
timestamps timestamps

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