Plush Nail - Laravel Schema Designer

branch

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
address_en string
address_ar string
phone string
longitude double
latitude double
city_id integer

service_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
show boolean
is_new boolean

product_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
show boolean
is_new boolean

service

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en string
description_ar string
duration integer
price double
rate integer
details_en string
details_ar string
show boolean
category_id integer
is_new boolean
odoo_id string

product

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
description_en string
description_ar string
price double
details_en string
details_ar string
show boolean
category_id integer
brand_id integer
is_new boolean
odoo_id string

worker

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
name_en string
name_ar string

worker_service

id increments
timestamps timestamps
softDeletes softDeletes
worker_id integer
service_id integer

shift

id increments
timestamps timestamps
softDeletes softDeletes
name string
from_hour string
to_hour string

working_day

id increments
timestamps timestamps
softDeletes softDeletes
worker_id integer
shift_id integer
day string
is_day_off boolean

slot

id increments
timestamps timestamps
softDeletes softDeletes
branch_id integer
date datetime
from_hour string
to_hour string
duration enum
max_uses integer
uses integer

offer

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
from_date datetime
to_date datetime
description_en string
description_ar string
show_product boolean
uses integer
discount_type enum
amount integer
to_buy enum
to_get enum
n_services integer

offer_service

id increments
timestamps timestamps
softDeletes softDeletes
offer_id integer
service_id integer

offer_product

id increments
timestamps timestamps
softDeletes softDeletes
offer_id integer
product_id integer

order

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
date datetime
type enum
total_duration string
services_price double
private_price double
total_price double
status enum
offer_id integer
discount_id integer
rating_id integer
branch_id integer
odoo_id string

order_service

id increments
timestamps timestamps
softDeletes softDeletes
service_id integer
order_id integer
worker_id integer

order_slot

id increments
timestamps timestamps
softDeletes softDeletes
slot_id integer
order_service_id integer

rating

id increments
timestamps timestamps
order_id integer
softDeletes softDeletes
question1 string
question2 string
question3 string
question4 string
question5 string
total_rate integer
show boolean
review string
branch_id integer

rating_service

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
rating_id integer
service_id integer
worker_id integer
rate integer
show boolean
review string
branch_id integer

brand

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

discount

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
code string
discount_type enum
amount double
from_date datetime
to_date datetime
max_uses integer
uses integer

service_branch

id increments
timestamps timestamps
softDeletes softDeletes
service_id integer
branch_id integer

product_branch

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
branch_id integer

schedule

id increments
timestamps timestamps
softDeletes softDeletes
days string
from_hour string
to_hour string
is_day_off boolean
branch_id integer

city

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

slot_view

id increments
timestamps timestamps
softDeletes softDeletes
day integer
branch_id integer
max_uses integer

client

id increments
timestamps timestamps
softDeletes softDeletes
name string
last_name string
phone string
email string
birth_date datetime
work_field integer
work_name string

user

id increments
timestamps timestamps
softDeletes softDeletes

offer_branch

id increments
timestamps timestamps
softDeletes softDeletes
offer_id integer
branch_id integer

discount_branch

id increments
timestamps timestamps
softDeletes softDeletes
discount_id integer
branch_id integer

offer_getservice

id increments
timestamps timestamps
softDeletes softDeletes
service_id integer
offer_id integer

offer_getproduct

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
offer_id integer

user_branches

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
branch_id string

campaign

id increments
timestamps timestamps
softDeletes softDeletes
title mediumText
content longText

slot_hour

id increments
timestamps timestamps
softDeletes softDeletes
from_hour string
to_hour string

slot_view_hour

id increments
timestamps timestamps
softDeletes softDeletes
slot_hour_id integer
slot_view_id integer

offdays

id increments
timestamps timestamps
softDeletes softDeletes
date date
branch_id integer