park&wash - Laravel Schema Designer

country

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
code string
currency_en string
currency_ar string

mall

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
country_id integer
name_en string
name_ar string
area_id integer

car

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

service

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
car_id integer
service_type_id integer
price double

supply

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
quantity integer
damaged integer
barcode string
description_en text
description_ar text

order

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
country_id integer
mall_id integer
user_id integer
service_id integer
car_number string
payment_method enum
discount_percent integer
total double
status string
park_id integer
client_name string
client_phone string
is_client boolean

request

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
mall_id integer
country_id integer
received_at timestamp
status enum

request_item

id increments
timestamps timestamps
softDeletes softDeletes
request_id integer
supply_id integer
quantity integer

user

id increments
timestamps timestamps
softDeletes softDeletes

service_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

supply_country

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
supply_id integer

car_country

id increments
timestamps timestamps
softDeletes softDeletes
car_id integer
country_id integer

address

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
address_en string
address_ar string

category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

product

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
price double
category_id integer
country_id integer
description_en string
description_ar string
code string

option_category

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

option

id increments
timestamps timestamps
softDeletes softDeletes
option_category_id integer
name_en string
name_ar string
description_en string
description_ar string

product_option

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
country_id integer
option_category_id integer
option_id integer
price double

client_order

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
country_id integer
total double
payment_method enum
status enum

order_product

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
product_id integer
price double

payment_method

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

user_meta

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
player_id string (200)
user_id integer

order_option

id increments
timestamps timestamps
softDeletes softDeletes
order_product_id integer
option_id integer
price double

stock_in

id increments
timestamps timestamps
softDeletes softDeletes
supply_id integer
quantity integer
user_id integer
country_id string
price double
total double
description_en text
description_ar text
bill_no string

mall_stock

id increments
timestamps timestamps
softDeletes softDeletes
supply_id integer
quantity integer
damaged integer
mall_id integer

damage_request

id increments
timestamps timestamps
softDeletes softDeletes
mall_id integer
supply_id integer
quantity integer
user_id integer

revenue_report

timestamps timestamps
softDeletes softDeletes
id increments
date datetime
country_id integer
mall_id integer
sedan integer
jeep integer
vip integer
vvip integer
subscription double
total_wash integer
total_money double
expenses double
net_sale double
p_seat integer
p_gear string
p_steering integer
p_mat integer
bag integer
seat integer
gear integer
steering integer

expense

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
user_id integer
amount double
date datetime
type string
group string
from string
description text
description_ar text

category_country

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
category_id integer

stock

id increments
timestamps timestamps
softDeletes softDeletes
supply_id integer
quantity integer
damaged integer
user_id integer
country_id integer

park

id increments
timestamps timestamps
softDeletes softDeletes
mall_id integer
park string

area

id increments
timestamps timestamps
softDeletes softDeletes
area string
country_id integer

cover

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

cover_price

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
service_id integer
cover_id integer
price double

order_cover

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
cover_id integer
quantity integer
price double
total double
country_id integer

service_cover

id increments
timestamps timestamps
softDeletes softDeletes
service_id integer
cover_id integer
quantity integer