bst_wn_db - Laravel Schema Designer

products

id increments
country_id ^FK integer
region_id ^FK integer
type_id ^FK integer
grape_id ^FK integer
name string (255)
image text
content text
quantity integer
price bigInteger
concentration string (10)
capacity string (10)
is_active tinyInteger
is_discount tinyInteger
discount_value bigInteger
is_new tinyInteger
is_highlight tinyInteger
timestamps timestamps

regions

id increments
country_id ^FK integer
name string (255)
timestamps timestamps

countries

id increments
name string (255)
timestamps timestamps

manufacturers

id increments
name string (255)
image text
description text
nation string (100)
timestamps timestamps

types

id increments
name string (255)
timestamps timestamps

grapes

id increments
name string (255)
timestamps timestamps

orders

id increments
total_price bigInteger
discount_percent integer
discounted_price bigInteger
payment_method tinyInteger
code string (10)
status tinyInteger
timestamps timestamps

order_customers

id increments
order_id ^FK integer
name string (255)
address text
phone string (20)
email string (100)
timestamps timestamps

order_items

id increments
order_id ^FK integer
item_id ^FK integer
type tinyInteger
quantity integer
price bigInteger
timestamps timestamps

combo

id increments
name string (255)
image text
description text
content text
price bigInteger
is_discount tinyInteger
discount_value bigInteger
is_active tinyInteger
is_highlight tinyInteger
is_new tinyInteger
timestamps timestamps

combo_products

id increments
product_id integer
combo_id integer
timestamps timestamps

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