l5hotel - Laravel Schema Designer

bookings

id increments
user_id bigInteger
hotel_id integer
payment_id integer
booking_status_id integer
payment_status_id integer
description text
price decimal
vat decimal
check_in datetime
check_out datetime

facilities

id increments
title string (250)
description text

hotels

id increments
title string (250)
address string (250)
ward_id integer
district_id integer
city_id integer
country_id integer
description text
phone string (20)
mobile string (20)
email string (250)
lattitude float
longitude float
rating integer
rate_count integer

rooms

id increments
hotel_id bigInteger
room_type_id integer
room_status_id integer
max_adults integer
max_children integer
max_extra_beds integer
number_of_rooms integer
beds integer
bathrooms integer
room_area decimal
price decimal
extra_bed_charge decimal

rooms_facilities

room_id integer
facility_id integer

customers

id increments
user_id ^FK integer
first_name string
last_name string
phone string (20)
mobile string (20)
dob datetime

rooms_bookings

room_id integer
booking_id integer

users

id increments
role_id integer
name string
email string
password string
remember_token string

roles

id increments
role string
description string

room_types

id increments
type_name string
description string
active boolean

room_status

id increments
status string
description string
active boolean

booking_status

id increments
status string
description string
active boolean

payments

id increments
customer_id integer
payment_method_id integer
payment_status_id integer
payment_amount decimal
date datetime

payment_methods

id increments
payment_method string

payment_status

id increments
status string
description string
active boolean

hotel_images

id increments
hotel_id integer
image_url string
description string

room_images

id increments
room_id integer
image_url string
description string

wards

id increments
ward string
district_id integer

districts

id increments
district string
city_id integer

cities

id increments
city string
country_id integer

countries

id increments
country string

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