store - Laravel Schema Designer

products

id increments
timestamps timestamps
sku string
quantity integer
saled_quantity integer
available_quantity integer
is_active string
featured integer
allow_reviews enum
low_stock integer
slug string
restock integer
purchase_note string
company_id ^FK integer
created_by ^FK integer
length string
height string
width string
discount_value double
discount_type enum
deleted_at timestamp

categories

id increments
timestamps timestamps
parent_id integer
icon string

orders

id increments
timestamps timestamps
code string
total_price double
coupon_id ^FK integer
total_after_discount double
phone string
name string
email string
government_id integer
city_id ^FK integer
address string
customer_id ^FK integer
payment_method_id ^FK integer
receivedDate date
status enum
address_id ^FK integer

order_product

id increments
timestamps timestamps
product_id ^FK integer
order_id ^FK integer
price double
quantity integer

coupons

id increments
timestamps timestamps
code string
is_active integer
status enum
value integer
min_amount double
max_amount string
usege_per_user_limit integer
usage_limit integer
free_shipping integer
expire_date date

customers

id increments
timestamps timestamps
name string
email string
password string
phone string

coupon_customer

id increments
timestamps timestamps
coupon_id ^FK integer
customer_id ^FK integer

shipping_companies

id increments
timestamps timestamps
logo string
price double
estimated_time string

reviews

id increments
timestamps timestamps
rate integer
name string
content string
customer_id ^FK integer
product_id ^FK integer

settings

id increments
timestamps timestamps

setting_categories

id increments
timestamps timestamps

attachments

id increments
timestamps timestamps
path string
type enum
usage string
attachmentable_type string
attachmentable_id integer

product_translations

id increments
timestamps timestamps
name string
short_description string
product_id ^FK integer
locale string
content longText

payment_methods

id increments
timestamps timestamps
visible integer
order integer

governments

id increments
timestamps timestamps
code string
name string

cities

id increments
timestamps timestamps
code string
name string

reasons

id increments
timestamps timestamps
order_id ^FK integer
reason string

couponables

id increments
timestamps timestamps
coupon_id ^FK integer
couponable_id integer
couponable_type string

category_translations

id increments
timestamps timestamps
name string
locale string
category_id ^FK integer

addresses

id increments
timestamps timestamps
address text
city_id ^FK integer
government_id ^FK integer
customer_id ^FK integer
status enum
name string
phone string

shipping_company_translations

id increments
timestamps timestamps
name string
shipping_company_id ^FK integer
locale string

companies

id increments
timestamps timestamps

payment_method_translations

id increments
timestamps timestamps
locale string
name string
description longText
note longText
payment_method_id ^FK integer

company_translations

id increments
timestamps timestamps
name string
locale string
company_id ^FK integer

users

id increments
timestamps timestamps
name string
email string
phone string
password string
is_admin integer

categorables

id increments
timestamps timestamps
categorable_id integer
category_id ^FK integer
categorable_type string

posts

id increments
timestamps timestamps
slug string
created_by ^FK integer

post_translations

id increments
timestamps timestamps
title string
content string
post_id ^FK integer
locale string