telvery - Laravel Schema Designer

settings

id increments
phone string
email string
address_ar string
address_en string
footer_desc_ar text
footer_desc_en text
title_ar string
title_en string
about_ar text
about_en text
timestamps timestamps

contacts

id increments
first_name string
last_name string
phone string
email string
message text
timestamps timestamps

governorates

id increments
name_ar string
name_en string
timestamps timestamps

teams

id increments
name_ar string
name_en string
job_ar string
job_en string
timestamps timestamps

photos

id increments
path text
type enum
photoable_id integer
photoable_type string
timestamps timestamps

subscriptions

id increments
email string
timestamps timestamps

questions

id increments
question_ar string
question_en string
answer_ar text
answer_en text
timestamps timestamps

clients

id increments
first_name string
last_name string
email string
phone string
address string
password string
pin_code string
activated tinyInteger
governorate_id ^FK integer
timestamps timestamps

coupons

id increments
num_users integer
expiry_date date
discount double
code string
timestamps timestamps

brands

id increments
name_ar string
name_en string
timestamps timestamps

categories

id increments
name_ar string
name_en string
parent_id ^FK integer
timestamps timestamps

products

id increments
name_ar string
name_en string
user_id ^FK integer
brand_id ^FK integer
category_id ^FK integer
total_qty integer
color string
specification_ar text
specification_en text
video string
detail_ar text
detail_en text
sku string
black_friday tinyInteger
today_deal tinyInteger
timestamps timestamps

users

id increments
name string
email string
timestamps timestamps

reviews

id increments
client_id ^FK integer
product_id ^FK integer
comment text
rate enum
timestamps timestamps

sliders

id increments
title_ar string
title_en string
timestamps timestamps

payment_methods

id increments
name_ar string
name_en string
timestamps timestamps

shippings

id increments
client_id ^FK integer
governorate_id ^FK integer
address string
zip_code string
phone string
timestamps timestamps

client_product

id increments
client_id ^FK integer
product_id ^FK integer
timestamps timestamps

carts

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

delivery_costs

id increments
product_id ^FK integer
governorate_id ^FK integer
price double
timestamps timestamps

orders

id increments
status enum
client_id ^FK integer
coupon_id ^FK integer
payment_method_id ^FK integer
total_price double
delivery_cost double
transaction_id string
shipping_id ^FK integer
timestamps timestamps

order_product

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

bought_togethers

id increments
des_product_id ^FK integer
product_id ^FK integer
timestamps timestamps

sizes

id increments
product_id ^FK integer
type string
in_stock integer
price_after double
price_before double
timestamps timestamps

replies

id increments
client_id ^FK integer
review_id ^FK integer
comment text
timestamps timestamps

favourites

id increments
client_id ^FK integer
review_id ^FK integer
type tinyInteger
timestamps timestamps

colors

id increments
name string
code string
timestamps timestamps

become_users

id increments
email string
phone string
activation tinyInteger
timestamps timestamps