ecommerceproducts - Laravel Schema Designer

coupons

id increments
value string (255)
start_date date
end_date date
number integer
name string (255)
code string (255)
type string
times string (255)
price string (255)
category_id ^FK integer
product_id ^FK integer
softDeletes softDeletes
timestamps timestamps

ratings

id increments
user_id ^FK integer
product_id ^FK integer
review string (255)
rating string (255)
type string
comment string
softDeletes softDeletes
timestamps timestamps

users

id increments
first_name string (255)
last_name string (255)
type enum
address string (255)
phone string (255)
fax string (255)
email string (255)
password string
image string (255)
store_name string (255)
store_link string
firebase_token string (255)
email_verified_at string (255)
status boolean
softDeletes softDeletes
timestamps timestamps

roles

id increments
name string
description string
softDeletes softDeletes
timestamps timestamps

permissions

id increments
name string
description string
softDeletes softDeletes
timestamps timestamps

sliders

id increments
image string
title_ar string
title_en string
content_ar string
content_en string
softDeletes softDeletes
timestamps timestamps

tags

id increments
name_ar string
name_en string
softDeletes softDeletes
timestamps timestamps

comments

id increments
product_id ^FK integer
user_id ^FK integer
text text
softDeletes softDeletes
timestamps timestamps

articles

id increments
name_ar string
name_en string
description_ar string
description_en string
image string
softDeletes softDeletes
timestamps timestamps

pages

id increments
name_ar string
name_en string
type string
slug string
description_ar string
description_en string
status boolean
softDeletes softDeletes
timestamps timestamps

notifications

id increments
title_ar string
title_en string
content_ar text
content_en text
user_id ^FK integer
softDeletes softDeletes
timestamps timestamps

services

id increments
name_ar string
name_en string
description_ar text
description_en text
image string
softDeletes softDeletes
timestamps timestamps

addresses

id increments
user_id ^FK integer
city string
country string
street string
default_address string
softDeletes softDeletes
timestamps timestamps

inquiries

id increments
user_id ^FK integer
name string
email string
descriptions string
softDeletes softDeletes
timestamps timestamps

brands

id increments
name_ar string
name_en string
image string
softDeletes softDeletes
timestamps timestamps

subscriptions

id increments
email string
user_id ^FK integer
softDeletes softDeletes
timestamps timestamps

bank_accounts

id increments
account_name string
account_number string
first_name string
iban string
email string
image string
softDeletes softDeletes
timestamps timestamps

investments

id increments
full_name string
email string
phone string
city string
age string
money string
experience string
softDeletes softDeletes
timestamps timestamps

products

id increments
name_ar string
name_en string
price string
discount_price string
code string
description_ar string
description_en string
image string
category_id ^FK integer
unit string
published boolean
extras string
tag_id ^FK integer
shop_id integer
quantity string
timestamps timestamps
softDeletes softDeletes

offers

id increments
start_at date
end_date date
discount string
product_id ^FK integer
category_id ^FK integer
softDeletes softDeletes
timestamps timestamps

countries

id increments
name_ar string
name_en string
status string
softDeletes softDeletes
timestamps timestamps

cities

id increments
name_ar string
name_en string
status boolean
country_id ^FK integer
softDeletes softDeletes
timestamps timestamps

orders

id increments
user_id ^FK integer
capon_id ^FK integer
address_id ^FK integer
bill_number string
payment_status enum
status boolean
total string
subtotal string
qrcode string
payment_type string
softDeletes softDeletes
timestamps timestamps

merchants

id increments
name_ar string
name_en string
phone string
address string
image string
category_id ^FK integer
published enum
commerical_number string
status boolean
commerical_img string
type string
latitude string
longitude string
parent_id ^FK integer
employe_id integer
description_ar text
description_en text
softDeletes softDeletes
timestamps timestamps

merchant_user

id increments
user_id ^FK integer
merchant_id ^FK integer
softDeletes softDeletes
timestamps timestamps

order_product

id increments
order_id ^FK integer
product_id ^FK integer
softDeletes softDeletes
timestamps timestamps

user_product

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

tenants

id increments
name string
domain string
database string
softDeletes softDeletes
timestamps timestamps