DAR - Laravel Schema Designer

categories

id increments
image string
name string (20)
title string
description string
timestamps timestamps

cities

id increments
name string
country_id ^FK bigInteger
timestamps timestamps

users

id increments
image string
fname string
lname string
email string
phone string
code string (4)
code_expire timestamp
city_id ^FK bigInteger
is_confirmed boolean
is_active boolean
is_notify boolean
rate_count integer
rate_avg decimal
confirmed_type enum
id_number integer
birth_date date
residency_number integer
passport_number integer
nationalty_id ^FK bigInteger
softDeletes softDeletes
timestamps timestamps

nationalties

id increments
name string
timestamps timestamps
softDeletes softDeletes

providers

id increments
image string
fname string
lname string
email string
phone string
code string
code_expire timestamp
city_id ^FK bigInteger
type enum
id_number integer
birth_date date
registration_number integer
release_date date
softDeletes softDeletes
timestamps timestamps

favourites

id increments
user_id ^FK bigInteger
unit_id ^FK bigInteger
timestamps timestamps

unites

id increments
estate_id ^FK bigInteger
name text
area decimal
persons_num integer
arrival_time time
leave_time time
description text
statment string
status enum
is_visible integer
timestamps timestamps

reservations

id increments
user_id ^FK bigInteger
unit_id ^FK bigInteger
is_confirmed boolean
type enum
status enum
arrival_date date
leave_date date
nights_num integer
price decimal
fees integer
offers_discount integer
coupon string
discount_amount decimal
total_price decimal
pay_status integer
pay_type integer
cancel_reason string
timestamps timestamps
user_name string
id_number integer
phone string
email string
country_id ^FK bigInteger
city_id ^FK bigInteger
amount_paid decimal

provider_rates

id increments
user_id ^FK bigInteger
unit_id ^FK bigInteger
public_rate integer
provider_rate integer
amenities_rate integer
clean_rate integer
information_rate integer
comment string
timestamps timestamps

user_rates

id increments
user_id ^FK bigInteger
unit_id ^FK bigInteger
rate integer
comment string
timestamps timestamps

packages

id increments
name string
price decimal
duration integer
softDeletes softDeletes
timestamps timestamps

estates

id increments
provider_id ^FK bigInteger
name text
area decimal
classification string
category_id ^FK bigInteger
city_id ^FK bigInteger
district_id ^FK bigInteger
direction_id ^FK bigInteger
lat decimal (10, 8)
lng decimal (10, 8)
map_desc text
softDeletes softDeletes
timestamps timestamps

districts

id increments
name string
city_id ^FK bigInteger
timestamps timestamps

directions

id increments
name string
timestamps timestamps

unit_details

id increments
unit_id ^FK bigInteger
facilitie_id ^FK bigInteger
facilities_description json
timestamps timestamps

facilities

id increments
name string
timestamps timestamps

facilities_details

id increments
facilitie_id ^FK bigInteger
label string
type enum
timestamps timestamps

addetional_facilities

id increments
name string
timestamps timestamps

unit_attachments

id increments
unit_id ^FK bigInteger
attachment string
type enum
timestamps timestamps

prices

id increments
unit_id ^FK bigInteger
day_on_week decimal
thursday_price decimal
friday_price string
saturday_price decimal
is_deposit tinyInteger
deposit_ratio integer
weeklly_discount_ratio integer
weeklly_discount_amount decimal
monthly_discount_ratio integer
monthly_discount_amount decimal
conditions string
timestamps timestamps

unit_availability

id increments
unit_id ^FK bigInteger
day string
date date
is_availability integer
timestamps timestamps

countries

id increments
name string
timestamps timestamps

booking_conditions

id increments
text string
timestamps timestamps

cancelled_policy

id increments
text string
timestamps timestamps

financial_transactions

id increments
provider_id ^FK bigInteger
reservation_id ^FK bigInteger
status string
price decimal
commission_amount decimal
vat_amount decimal
final_price decimal
due decimal
indebtedness decimal
timestamps timestamps

settlements

id increments
provider_id ^FK bigInteger
settlement_num string
amount decimal
total_admin_commission decimal
status enum
type enum
rejected_reason string
image string
timestamps timestamps

financial_transaction_settlements

id increments
settlement_id ^FK bigInteger
financial_transaction_id ^FK bigInteger
timestamps timestamps

sliders

id increments
image string
title string
timestamps timestamps

package_units

id increments
package_id ^FK bigInteger
unit_id ^FK bigInteger
is_subscribe integer
timestamps timestamps

contact_us

id increments
timestamps timestamps
userable morphs
title string
description text
type enum