Booking_clone - Laravel Schema Designer

photos

id increments
timestamps timestamps
photo string (255)
property_id ^FK integer

Properties

id increments
timestamps timestamps
UUID uuid
prorerty_code integer
property_status integer
price float
description text
property_size string (255)
address string (255)
country string (255)
city string (255)
Additional_fees string
longitude string (255)
latitude string (255)
status string (255)
hot string (255)
featured string (255)
user_id ^FK integer

users

id increments
timestamps timestamps
first_name string (255)
last_name string (255)
password string
email string (100)
phone_number string (50)
address string (500)
gender enum
role enum
profile_picture string (255)
status enum

rooms

id increments
timestamps timestamps
name string (255)
description text
price string
size string (255)
amenities string (255)
total_bathrooms integer
total_balconies integer
total_guests integer
featured_photo string
property_id ^FK integer

amenities

id increments
timestamps timestamps
amenities_name string (255)
property_id ^FK integer

property_types

id increments
timestamps timestamps
type_name string (255)
type_icon string (255)
property_id ^FK integer

rate_property

id increments
timestamps timestamps
user_id ^FK integer
proprty_id ^FK integer
comment text

orders

id increments
timestamps timestamps
propertiy_id ^FK integer
user_id ^FK integer
order_no bigInteger
booking_date datetime
check_in_date datetime
checko_out_date datetime
transaction_id string (100)
paid_amount float
status string (50)
payment_method string (255)

site_settings

id increments
timestamps timestamps
logo string (255)
address string (255)
support_phone string
email string (100)
copyright text
facebook string (255)
twitter string (255)

chat_messages

id increments
timestamps timestamps
sender_id ^FK integer
receiver_id ^FK integer
msg text

facilities

id increments
timestamps timestamps
facility_name string (255)

properties_facilities

id increments
timestamps timestamps
property_id ^FK integer
facility_id ^FK integer

contact_us

id increments
timestamps timestamps
user_id ^FK integer
msg text
contact_email string (100)

sliders

id increments
timestamps timestamps
title string (100)
image string (255)
description text

notifications

id increments
timestamps timestamps
notifiable_type string (100)
notifiable_id integer
data text

videos

id increments
timestamps timestamps
video_id string (255)
caption text
video_path string (255)
property_id ^FK integer

wishlists

id increments
timestamps timestamps
user_id ^FK integer
property_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01