ecommerce - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
password string
status boolean
type string
avatar string
phone string
disabled_at timestamp

roles

id increments
timestamps timestamps
softDeletes softDeletes

attributes

id increments
timestamps timestamps
softDeletes softDeletes
name string
status boolean

attribute_details

id increments
timestamps timestamps
softDeletes softDeletes
attribute_id ^FK integer
name string

products

id increments
timestamps timestamps
softDeletes softDeletes
sku string
name string
description text
tags string
category_id ^FK bigInteger
brand_id ^FK bigInteger
unit string
refundable boolean
free_shipping boolean
low_stock_quantity integer
show_stock_quantity boolean
cash_on_delivery boolean
todays_deal boolean
estimate_shipping integer
tax double
discount double
quantity integer
meta_title string
meta_description text
available boolean

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string
slug string
status boolean
parent_id ^FK bigInteger
order integer
icon string
banner string
show_in_navbar boolean

brands

id increments
timestamps timestamps
softDeletes softDeletes
name string
logo string
status boolean

product_offers

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK bigInteger
day_start datetime
day_end datetime
percentage double (2,2)
price double
quantity integer

orders

id increments
timestamps timestamps
softDeletes softDeletes
coupon_id ^FK bigInteger
user_id ^FK bigInteger
address_id ^FK bigInteger
tax_percentage decimal
type tinyInteger
payment tinyInteger
total_cost decimal
order_status_id ^FK bigInteger
total_products decimal
reference string

order_details

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
delivery_date datetime

comments

id increments
softDeletes softDeletes
timestamps timestamps
rate string
order_id ^FK bigInteger
rate_comment string
status boolean

cart_payments

id increments
timestamps timestamps
softDeletes softDeletes
method string
method_title string
order_id ^FK bigInteger

product_reviews

id increments
timestamps timestamps
softDeletes softDeletes
title string
rating integer
comment text
status boolean
product_id ^FK bigInteger
user_id ^FK bigInteger

product_images

id increments
timestamps timestamps
softDeletes softDeletes
type string
path string
product_id ^FK bigInteger

shipments

id increments
timestamps timestamps
softDeletes softDeletes
status string
total_qty integer
total_weight integer
carrier_code string
carrier_title string
track_number text
email_sent boolean
customer_id ^FK bigInteger
order_id ^FK bigInteger
order_address_id ^FK bigInteger

shipment_items

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string
qty string
weight string
price decimal
product_id ^FK bigInteger
order_item_id ^FK bigInteger
shipment_id ^FK bigInteger
additional json
product_type string
total_cost decimal

settings

timestamps timestamps
id increments
softDeletes softDeletes
key string
value text
status boolean
name string
setting_group_id ^FK integer
type enum

slides

id increments
timestamps timestamps
softDeletes softDeletes
image string
heading string
description text
link string
status boolean

contacts

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
subject string
message text

coupons

id increments
timestamps timestamps
softDeletes softDeletes
code string
type string
amount_type enum
amount double
from timestamp
to timestamp
status boolean

social_links

id increments
timestamps timestamps
name string
icon_code string
icon_color string
url string

wishlists

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK bigInteger
user_id ^FK bigInteger

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
status boolean

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string
state_code string
status boolean

addresses

id increments
timestamps timestamps
softDeletes softDeletes
address_1 string
address_2 string
state_code string
city_id ^FK bigInteger
country_id ^FK bigInteger
user_id ^FK bigInteger
status boolean

currencies

id increments
timestamps timestamps
softDeletes softDeletes

Transactions

id increments
timestamps timestamps
softDeletes softDeletes

pages

id increments
timestamps timestamps
softDeletes softDeletes
title string
content text
image text
status boolean

order_status

id increments
timestamps timestamps
softDeletes softDeletes
name string
status boolean

attribute_products

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK bigInteger
attribute_id ^FK bigInteger
value string

setting_groups

id increments
timestamps timestamps
softDeletes softDeletes
name string
image string
description text

ads

id increments
timestamps timestamps
softDeletes softDeletes
title string
url string
start_date date
end_date date

menus

id increments
timestamps timestamps
softDeletes softDeletes
title string
parent_id ^FK bigInteger
status boolean
show_in_navbar boolean
url string
sort integer