DAR - Laravel Schema Designer

categories

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

cities

id increments
name string
country_id ^FK bigInteger
timestamps timestamps

users

id increments
image string
fname string
lname string
email string
city_id ^FK bigInteger
country_code string (5)
phone string
code string (4)
code_expire timestamp
is_active boolean
is_notify boolean
rate_count integer
rate_avg decimal
is_confirmed boolean
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
city_id ^FK bigInteger
country_code string (5)
phone string
code string
code_expire timestamp
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
statement_status enum
is_visible boolean
timestamps timestamps

reservations

id increments
user_id ^FK bigInteger
estate_id ^FK bigInteger
unit_id ^FK bigInteger
type enum
status enum
arrival_date date
nights_num integer
total_nigths_price decimal
leave_date date
fees_amount integer
offers_discount double
coupon string
discount_amount decimal
total_price decimal
pay_type enum
pay_status 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
cancelled_by enum
fees_ratio double
discount_ratio string
commision_ration double
commision_amount double
arrival_time time
leave_time time
fulldate_time datetime
fullleave_time time

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
provider_id ^FK bigInteger

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
rate_count integer
rate_avg double
is_confirmed boolean
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
text string
timestamps timestamps
type enum

facilities_details

id increments
facilitie_id ^FK bigInteger
name string
type enum
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

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
type enum
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
imageable morphs
image string
title string
category_id ^FK bigInteger
city_id ^FK bigInteger
timestamps timestamps

package_units

id increments
package_id ^FK bigInteger
unit_id ^FK bigInteger
is_subscribe integer
timestamps timestamps
status string
expire_date date

contact_us

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

provider_banks_accounts

id increments
bank_name string
account_number string
owner_name string
iban string
timestamps timestamps
provider_id ^FK bigInteger