ecommerceapp - Laravel Schema Designer

products

id increments
id_store ^FK integer
id_brand ^FK integer
id_category ^FK integer
id_user ^FK integer
timestamps timestamps
softDeletes softDeletes
short_description string (600)
full_description text
base_price float (10,2)
code string (12)
views_count bigInteger
is_actived integer
views_counter integer

brands

id increments
timestamps timestamps
softDeletes softDeletes
name string (120)
url_web string (800)
url_image string (800)
contry string (200)
telephone string (25)
address string (300)
zip_code integer
city string (60)
state string (60)
url_logo string (300)

product_galerys

id increments
timestamps timestamps
id_product ^FK integer
url_image string (800)

reviews

id increments
timestamps timestamps
id_user integer
id_product ^FK integer
description text
counter_stars integer
is_active integer

attributes

id increments
timestamps timestamps
id_product ^FK integer
name string (100)
type integer
content text

product_configs

id increments
timestamps timestamps
id_product ^FK integer
review_is_active integer
due_date datetime
discount float (10,2)

stores

id increments
timestamps timestamps
softDeletes softDeletes
name string (200)
code string (20)

store_configs

id increments
timestamps timestamps
softDeletes softDeletes
country string (20)

orders

id increments
timestamps timestamps
id_user ^FK integer
id_purchase_address string (600)
status integer
payment_method string (200)

users

id increments
timestamps timestamps
role integer

orders_products

id increments
id_product ^FK integer
id_order ^FK integer
timestamps timestamps
quantity integer

inventorys

id increments
timestamps timestamps
id_product ^FK integer
quantity integer

categorys

id increments
timestamps timestamps
slug string (50)
name string (200)
description text

tied_products

id increments
timestamps timestamps
parent integer
child integer

store_logs

id increments
id_user ^FK integer
id_store ^FK integer
timestamps timestamps
type string (100)
description text

purchase_address

id increments
id_order ^FK integer
id_user ^FK integer
timestamps timestamps
shipping_address text
first_name string (120)
last_name string (200)
city string (100)
state string (60)
country string (60)
additional_comment text
zip_code integer

assigned_stores

id increments
timestamps timestamps
id_user ^FK integer
id_store ^FK integer

invoicings_config

id increments
timestamps timestamps
copyright string (120)
url_logo string (600)
footer_text string (600)

store_currencies

id increments
timestamps timestamps
id_store ^FK integer
currency string

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