Treat - Laravel Schema Designer

clients

id increments
name string (150)
phone string (55)
whatsapp_number string (55)
email string (100)
gender enum
age integer
birth_date date
address_lat string (55)
address_long string (55)
country_id ^FK integer
city_id ^FK integer
otp integer
image string (150)
status enum
timestamps timestamps
softDeletes softDeletes

countries

id increments
name string (100)
logo string (100)
key string (55)
code string (55)
timestamps timestamps
softDeletes softDeletes

cities

id increments
name string (100)
country_id ^FK integer
timestamps timestamps
softDeletes softDeletes

vendors

id increments
name string (150)
phone string (55)
whatsapp_number string (55)
email string (100)
password string (100)
address_lat string (55)
address_long string (55)
country_id ^FK integer
city_id ^FK integer
commercial_register string (55)
target_client_gender enum
vendor_type ^FK integer
package_id ^FK integer
commission_rate double
otp integer
status enum
classification enum
term_acceptance enum
timestamps timestamps
softDeletes softDeletes

vendor_type

id increments
name string (100)
note text
timestamps timestamps
softDeletes softDeletes

vendor_images

id increments
image string (150)
vendor_id ^FK integer
timestamps timestamps

settings

id increments
phone string (55)
email string (100)
whatsapp string (55)
facebook string (100)
banner string (150)
timestamps timestamps
softDeletes softDeletes
name string (150)
note text
image string (150)
video string (150)
address_lat string (55)
address_long string (55)

services

id increments
name string (150)
note text
service_category_id ^FK integer
branch_id ^FK integer
normal_price double
offer_type enum
offer_value double
offer_price double
offer_from_date date
offer_to_date date
points integer
for_gender enum
timestamps timestamps
softDeletes softDeletes

service_categories

id increments
name string (100)
note text
timestamps timestamps
softDeletes softDeletes
service_type_id ^FK integer

service_images

id increments
service_id ^FK integer
image string (150)
timestamps timestamps
softDeletes softDeletes

service_types

id increments
name string (150)
note text
timestamps timestamps
softDeletes softDeletes

client_points

id increments
client_id ^FK integer
service_id ^FK integer
points integer
order_id ^FK integer
status enum
timestamps timestamps
softDeletes softDeletes

orders

id increments
client_id ^FK integer
branch_id ^FK integer
type enum
transportation_amount double
paid enum
status enum
address_lat string (100)
address_long string (100)
district_id ^FK integer
coupon_id ^FK integer
timestamps timestamps
softDeletes softDeletes

order_details

id increments
order_id ^FK integer
service_id ^FK integer
count integer
amount double
timestamps timestamps
softDeletes softDeletes

client_wallets

id increments
client_id ^FK integer
timestamps timestamps
softDeletes softDeletes

payments

id increments
order_id ^FK integer
amount double
client_transaction_number string (100)
vendor_transaction_number string (100)
status enum
commission double
vendor_amount double
timestamps timestamps
softDeletes softDeletes

client_gifts

id increments
from_client_id ^FK integer
to_client_id ^FK integer
order_id ^FK integer
status enum
timestamps timestamps
softDeletes softDeletes

client_branch_favourites

id increments
client_id ^FK integer
branch_id ^FK integer
timestamps timestamps
softDeletes softDeletes

sliders

id increments
timestamps timestamps
softDeletes softDeletes
title string
note text
image string (150)

districts

id increments
name string (150)
city_id ^FK integer
timestamps timestamps
softDeletes softDeletes

carts

id increments
client_id ^FK integer
branch_id ^FK integer
service_id ^FK integer
count integer
timestamps timestamps
softDeletes softDeletes

rates

id increments
timestamps timestamps
softDeletes softDeletes
client_id ^FK integer
branch_id ^FK integer
rate integer
comment text

coupons

id increments
vendor_id ^FK integer
branch_id ^FK integer
service_category_id ^FK integer
service_id ^FK integer
all enum
discount_type enum
discount_amount boolean
start_date date
end_date date
max_use integer
uses integer
status enum
timestamps timestamps
softDeletes softDeletes

branches

id increments
vendor_id ^FK integer
name string (150)
phone string (55)
whatsapp_number string (55)
email string (100)
password string (100)
address_lat string (100)
address_long string (100)
city_id ^FK integer
target_client_gender enum
status enum
timestamps timestamps
softDeletes softDeletes

branch_images

id increments
branch_id ^FK integer
image string (100)
timestamps timestamps
softDeletes softDeletes

branch_districts

id increments
branch_id ^FK integer
district_id ^FK integer
timestamps timestamps
softDeletes softDeletes