restaurants - Laravel Schema Designer

users

timestamps timestamps
id increments

reservations

id increments
timestamps timestamps
user_id ^FK integer

reservation_room

id increments
timestamps timestamps
room_id ^FK integer
reservation_id ^FK integer

rooms

id increments
timestamps timestamps
accomodation_id ^FK integer

amenity_room

id increments
amenity_id integer
room_id ^FK integer

amenities

id increments
timestamps timestamps

rates

id increments
timestamps timestamps
room_id ^FK integer

cities

id increments
timestamps timestamps

states

id increments
timestamps timestamps

countries

id increments
timestamps timestamps

accomodations

id increments
timestamps timestamps
location_id ^FK integer

locations

id increments
timestamps timestamps
city_id ^FK integer
state_id ^FK integer
country_id ^FK integer

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