Bookings - Laravel Schema Designer

persons

id increments
firstName string (30)
lastName string (30)
adress_id integer
phone_id integer
email string
timestamps timestamps

guests

id increments
person_id ^FK integer
timestamps timestamps
type_documentation_id ^FK integer

reservations

id increments
uuid integer
guest_id ^FK integer
date_from date
date_to date
total_price decimal (6,2)
payment_id integer
number_rooms integer
reservation_status_id ^FK integer
created_by string
updated_by string
reservation_type_id string
timestamps timestamps

reser_room

id increments
reservation_id ^FK integer
room_id ^FK integer

rooms

id increments
room_type_id ^FK integer
isAvailable boolean
max_adults tinyInteger
max_childs tinyInteger
timestamps timestamps
floor integer
price decimal (6,3)
description string (100)

room_type

id increments
desc string (20)

reservation_status

id increments
status string

employees

id increments
person_id ^FK integer
timestamps timestamps
user_id string

room_amanities

id increments
room_id ^FK integer
amantities_id ^FK integer

amanities

id increments
desc string

reservation_type

id increments
type string (40)

payment

id increments
payment_method_id string
payment_amount integer
payment_status_id integer
date datetime
timestamps timestamps

payment_method

id increments
methods string (20)
timestamps timestamps

payment_status

id increments
status string (30)
timestamps timestamps

guest_guest

id increments
guest_id string
type_guest_id string
number tinyInteger
birthdate date

type_documentation

id increments
identification string
timestamps timestamps
photo_documentation binary

type_guest

id increments
timestamps timestamps
type string (20)

room_photos

id increments
timestamps timestamps
room_id ^FK integer
image binary

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