Home
l5hotel
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for l5hotel
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01