exponent10 - Laravel Schema Designer

brands

id increments
name string (255)

models

id increments
name string (255)
brand_id ^FK integer

products

id increments
timestamps timestamps
name string (255)
description text
short_description string (255)
price decimal (10,2)
type_id ^FK integer
model_id ^FK integer
visibility_id ^FK integer
tax_group_id integer

types

id increments
name string (255)

categories

id increments
name string (255)
slug string (255)

category_parents

parent_id ^FK integer
category_id ^FK integer

procduct_categories

product_id ^FK integer
category_id ^FK integer

visibilities

id increments
name string (255)

images

id increments
path_image string (500)
product_id ^FK integer
combination_id ^FK integer

combinations

id increments
price_impact decimal (10,2)
product_id ^FK integer
combinaison_value_id ^FK integer

combinaison_values

id increments
name string (255)
combinaison_attribute_id ^FK integer

combinaison_attributes

id increments
name string (255)

stocks

id increments
name string (255)
quantity integer
product_id ^FK integer
combination_id ^FK integer
location_id ^FK integer

locations

id increments
name string (255)
address string (255)
city string (255)

order_details

id increments
name string (255)
quantity bigInteger
unit_price bigInteger
category string (255)
model string (255)
brand string (255)
product_id ^FK integer
combination_id ^FK integer
order_id ^FK integer
combination_value string
combination_attribute string

orders

id increments
timestamps timestamp
company_name string (255)
company_address string
company_tel string (255)
customer_firstname string (255)
customer_lastname string (255)
customer_address string (255)
customer_email string (255)
customer_tel string
customer_id ^FK integer

customers

id increments
firstname string (255)
lastname string
address string (255)
email string
tel string

order_totals

total_type_name string (255)
total_type_position integer
total_amount bigInteger
order_id ^FK integer
total_type_id ^FK integer

total_types

id increments
name string (255)
position integer
value bigInteger
is_percentage boolean

order_taxes

id increments
taxe_type_name string (255)
taxe_type_value integer
order_detail_id ^FK integer

taxes

id increments
name string (255)
value integer
tax_address_id ^FK integer
geo_zone_id ^FK integer

tax_groups

id increments
name string

geo_zone_zones

geo_zone_id ^FK integer
zone_id ^FK integer

zones

id increments
country_id ^FK integer
state_id ^FK integer

tax_addresses

id increments
name string (255)

tax_groups_taxes

tax_group_id ^FK integer
tax_id ^FK integer

geo_zones

id increments
name string

states

id increments
name string

countries

id increments
name string

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