dorra - Laravel Schema Designer

products

id increments
name string
description longText
category_id ^FK bigInteger
sub_category_id ^FK bigInteger
free_shipping boolean
is_drafted boolean
price decimal
timestamps timestamps
softDeletes softDeletes

tags

id increments
name string
timestamps timestamps

product_tag

product_id ^FK bigInteger
tag_id ^FK bigInteger
timestamps timestamps

categories

id increments
name string
parent_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

carts

id increments
user_id ^FK bigInteger
product_id ^FK bigInteger
cookie_id char (36)
quantity integer
price decimal
timestamps timestamps

users

id increments
first_name string
last_name string
email string
phone_number string
status tinyInteger
country_code_id ^FK bigInteger
last_login_ip string (45)
last_login_at timestamp
timestamps timestamps

country_codes

id increments
country_name string
iso_code string (3)
phone_code string (5)
timestamps timestamps

discounts

id increments
code char (36)
type string
value decimal
start_date date
end_date date
timestamps timestamps

discount_product

product_id ^FK bigInteger
discount_id ^FK bigInteger
timestamps timestamps

orders

id increments
user_id ^FK bigInteger
sub_total decimal
discount double
shipping decimal
tax double
total decimal
status string
timestamps timestamps
softDeletes softDeletes

order_product

order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
price decimal
timestamps timestamps

reviews

id increments
timestamps timestamps
review string
rate tinyInteger
user_id ^FK bigInteger
product_id ^FK bigInteger

product_variants

id increments
product_id ^FK bigInteger
color_id ^FK bigInteger
available_stock bigInteger
timestamps timestamps

product_prices

id increments
quantity decimal
sale_price decimal
product_id ^FK bigInteger
timestamps timestamps

colors

id increments
name string
hex_code string
timestamps timestamps

social_accounts

id increments
user_id ^FK bigInteger
provider string
provider_id string
timestamps timestamps

notification_settings

id increments
key string
value string
timestamps timestamp

notification_setting_user

id increments
user_id ^FK integer
notification_setting_id ^FK bigInteger
timestamps timestamps

countries

id increments
name string
timestamps timestamps

states

id increments
timestamps timestamps
name string
country_id ^FK bigInteger

shipping_addresses

id increments
user_id ^FK bigInteger
name string
address string
state_id ^FK bigInteger
timestamps timestamps

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