l5hotel - Laravel Schema Designer

bookings

id increments
description text
booking_number string (20)
payment_type integer
payment_method integer
price decimal
vat decimal
payment decimal
pre_payment decimal
additional_payment decimal
payment_status integer
check_in datetime
check_out datetime
user_id bigInteger
timestamps timestamps
softDeletes softDeletes

campaigns

id increments
title string (250)
type integer
start_date datetime
end_date datetime
discount integer
timestamps timestamps
softDeletes softDeletes

coupons

id increments
description text
title string (250)
coupon_code string (10)
start_date datetime
end_date datetime
discount integer
timestamps timestamps
softDeletes softDeletes

extras

id increments
title string (250)
description text
price decimal
count integer
timestamps timestamps
softDeletes softDeletes

facilities

id increments
title string (250)
description text
timestamps timestamps
softDeletes softDeletes

hotels

id increments
timestamps timestamps
softDeletes softDeletes
title string (250)
address string (250)
description text
phone string (20)
mobile string (20)
fax string (20)
email string (250)
location integer
stars integer
timezone integer
image string (250)

meal_plans

id increments
title string (250)
description text
hotel_id ^FK bigInteger
charge_type integer
price decimal
timestamps timestamps
softDeletes softDeletes

packages

id increments
title string (250)
start_date datetime
end_date datetime
minimum_nights integer
maximum_nights integer
timestamps timestamps
softDeletes softDeletes

rooms

id increments
hotel_id ^FK bigInteger
type 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
timestamps timestamps
softDeletes softDeletes

rooms_facilities

id increments
room_id ^FK bigInteger
facility_id ^FK bigInteger

customers

id increments
address string
address2 string
city string (50)
postal_code string (10)
country integer
state integer
phone string (20)
mobile string (20)
fax string (20)
user_id bigInteger
dob datetime
company string (1000)
comments text
send_notification tinyInteger
timestamps timestamps
softDeletes softDeletes

rooms_bookings

id increments
room_id ^FK bigInteger
booking_id ^FK bigInteger

cart

id increments
timestamps timestamps
softDeletes softDeletes

invoices

id increments
timestamps timestamps
softDeletes softDeletes

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