Meawmah-diagram - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
phone string (50)
country_code string (10)
email string (100)
password string (50)
code string (10)
wallet double (8,2)
country_id ^FK integer
region_id ^FK integer
city_id ^FK integer
image string (50)

countries

id increments
timestamps timestamps
name string (100)
image string (50)
key string (191)

regions

id increments
timestamps timestamps
name string (50)
country_id ^FK integer

cities

id increments
timestamps timestamps
name string (50)
region_id ^FK integer

categories

id increments
timestamps timestamps
name string (100)
image string (50)

account_types

id increments
timestamps timestamps
name string (50)

ads

id increments
timestamps timestamps
image string (100)

cancel_reasons

id increments
timestamps timestamps
text text
type integer

complains

id increments
timestamps timestamps
phone string (50)
country_code string (10)
reason text
notes text
order_id ^FK integer

faqs

id increments
timestamps timestamps
question text
answer text
type integer

settings

id increments
timestamps timestamps
about_us_ar text
about_us_en text
who_us_ar text
who_us_en string
terms_ar text
terms_en text
privacy_ar text
privacy_en text

notifications

id increments
timestamps timestamps
type integer
notifiable morphs
data text
read_at datetime

images

id increments
timestamps timestamps
image string (100)
toable morphs

contactus

id increments
timestamps timestamps
name string (100)
phone string (100)
title string (150)
text text

services

id increments
timestamps timestamps
name string (100)
category_id ^FK integer

intros

id increments
timestamps timestamps
iamge string (50)
title string (150)
description text

providers

id increments
timestamps timestamps
type_id ^FK integer
name string (100)
email string (100)
national_id string (150)
phone string (100)
country_code string (10)
logo string (100)
commercial_id string (150)
country_id ^FK integer
region_id ^FK integer
city_id ^FK integer
lat double (8.2)
lng double (8,2)
map_desc text
bank_name string (150)
account_number string (150)
iban string (150)
has_deposit boolean
deposit double (8,2)
PASSW string (150)
lang string (50)
category_id ^FK integer
code string (50)
is_approved boolean
wallet double (8,2)
service_rate double (8,2)
speed_rate double (8,2)
communication_rate double (8,2)

provider_services

id increments
timestamps timestamps
provider_id ^FK integer
service_id ^FK integer

plans

id increments
timestamps timestamps
image string (100)
name string (100)
duration integer
price double (8,2)

subscriptions

id increments
timestamps timestamps
paln_id ^FK integer
provider_id ^FK integer
start_at datetime
end_at datetime
pay_staus integer
pay_type integer
unsubscripe boolean

orders

id increments
timestamps timestamps
number string (50)
provider_id ^FK integer
user_id ^FK integer
status integer
pay_staus integer
pay_type integer
city_id ^FK integer
lat double (8,2)
lng double (8,2)
map_desc text
date date
time time
notes text
record string (150)
invoice string (100)
offer_amount double (8,2)
deposit double (8,2)
price double (8,2)
vat double (8,2)
admin_commission double (8,2)
admin_commission_ratio decimal (8,2)
final_total double (8,2)
provider_type_id ^FK integer
cancel_reason text

order_services

id increments
timestamps timestamps
order_id ^FK integer
service_id ^FK integer

offers

id increments
timestamps timestamps
provider_id ^FK integer
order_id ^FK integer
amount double (8,2)
deposit double (8,2)
status integer

rates

id increments
timestamps timestamps
userable morphs
reviewable morphs
comment text
show boolean
service_rate double (8,2)
speed_rate double (8,2)
communication_rate double (8,2)
rate double (8,2)

provider_updates

id increments
timestamps timestamps
type_id integer
name string (100)
email string (100)
national_id string (150)
logo string (100)
commercial_id string (150)
country_id integer
region_id integer
city_id integer
lat double (8.2)
lng double (8,2)
map_desc text
bank_name string (150)
account_number string (150)
iban string (150)
has_deposit boolean
deposit double (8,2)
lang string (50)
category_id integer
code string (50)
is_approved boolean

provider_services_updates

id increments
timestamps timestamps
provider_id integer
service_id integer

image_updates

id increments
timestamps timestamps
image string (100)
toable morphs