dearro - Laravel Schema Designer

products

id increments
title string
brand_id ^FK integer
price string
old_price float
action_id integer
availability tinyInteger
is_new string
external_id string
timestamps timestamps

categories

id increments
title string
description text
image string
timestamps timestamps

products_categories

product_id ^FK integer
category_id ^FK integer

options

id increments
title string

options_categories

option_id ^FK integer
category_id ^FK integer

options_values

product_id ^FK integer
option_id ^FK integer
value string

organizations

id increments
name string
director string
inn string
address string
birth string
phone string
addresses text
timestamps timestamps
user_id string

orders

id increments
organization_id integer
entity_id integer
number string
timestamps timestamps

purchases

id increments
order_id integer
product_id integer
sizes_id integer
price float
count integer
timestamps timestamps

brands

id increments
title string
description text
sizes_table string
external_id string
timestamps timestamps

sizes

id increments
timestamps timestamps
value string
key string

markets

id increments
title string
country string
city string
address string
phone string
email string
instagram string
site string
external_id string
timestamps timestamps

actions

id increments
title string
timestamps timestamps

markets_brands

brand_id ^FK integer
market_id ^FK integer

products_images

id increments
product_id ^FK integer
image text
timestamps timestamps

users

id increments
email string
timestamps timestamps

analysis_sales

id increments
purchase_id string
sales_sum float
discount_sum float
sales_proc float
discount_proc float
sales float
saldo float
timestamps timestamps

analysis_orders

id increments
purchase_id integer
shipped integer
saldo integer
timestamps timestamps

products_sizes

id increments
size string
count integer
product_id integer
timestamps timestamps

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