Cloudbeds
Explore the interactive ERD
Table & Field Reference
house_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | FK |
account_name | Unknown | |
account_status | Unknown | |
date_created | Unknown | |
is_private | Unknown |
source_tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
source_id | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
name | Unknown | |
type | Unknown |
source_fee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
source_id | Unknown | PKFK |
amount | Unknown | |
amount_type | Unknown | |
name | Unknown | |
type | Unknown |
source_property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | FK |
commission | Unknown | |
is_third_party | Unknown | |
name | Unknown | |
payment_collect | Unknown | |
status | Unknown |
hotel_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
additional_photos | Json | |
address_1 | Unknown | |
address_2 | Unknown | |
amenities | Json | |
check_in_time | Unknown | |
check_out_time | Unknown | |
city | Unknown | |
company_legal_name | Unknown | |
country | Unknown | |
email | Unknown | |
late_check_out_allowed | Unknown | |
late_check_out_type | Unknown | |
late_check_out_value | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
phone | Unknown | |
primary_language | Unknown | |
state | Unknown | |
tax_id | Unknown | |
tax_id_2 | Unknown | |
terms_and_conditions | Unknown | |
zip | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | FK |
apply_to | Unknown | |
displayed | Json | |
is_personal | Unknown | |
max_characters | Unknown | |
name | Unknown | |
required | Unknown | |
short_code | Unknown | |
type | Unknown |
hotel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
currency_code | Unknown | |
currency_position | Unknown | |
currency_symbol | Unknown | |
description | Unknown | |
image | Unknown | |
name | Unknown | |
timezone | Unknown |
payment_allocation_house
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payment_id | Unknown | PKFK |
amount | Unknown | |
name | Unknown | |
reference | Unknown | |
type | Unknown |
payment_house
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
guest_id | Unknown | FK |
house_account_id | Unknown | FK |
property_id | Unknown | FK |
reservation_id | Unknown | FK |
room_id | Unknown | FK |
transaction_id | Unknown | FK |
amount | Unknown | |
currency | Unknown | |
description | Unknown | |
is_allocated | Unknown | |
is_deleted | Unknown | |
is_posted | Unknown | |
is_voided | Unknown | |
payment_method | Unknown | |
quantity | Unknown | |
state | Unknown | |
total_allocated | Unknown | |
total_unallocated | Unknown | |
user_id | Unknown | |
user_name | Unknown |
allotment_interval
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
allotment_block_id | Unknown | PKFK |
room_type_id | Unknown | FK |
availability | Json | |
end_date | Unknown | |
rate_id | Unknown | |
restrictions | Json | |
start_date | Unknown |
allotment_block
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | FK |
allotment_block_name | Unknown | |
allotment_type | Unknown | |
auto_release_release_days | Unknown | |
auto_release_release_schedule | Unknown | |
auto_release_release_time | Unknown | |
auto_release_release_type | Unknown | |
group_code | Unknown | |
is_auto_release | Unknown | |
rate_id | Unknown | |
rate_type | Unknown | |
status | Unknown |
room
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
room_type_id | Unknown | FK |
blocked | Unknown | |
description | Unknown | |
name | Unknown | |
property_id | Unknown |
reservation
| Column | Type | Keys |
|---|---|---|
reservation_id | Unknown | PK |
property_id | Unknown | FK |
date_created | Unknown | |
date_modified | Unknown |
transaction
| Column | Type | Keys |
|---|---|---|
transaction_id | Unknown | PK |
guest_id | Unknown | FK |
house_account_id | Unknown | FK |
property_id | Unknown | FK |
reservation_id | Unknown | FK |
room_type_id | Unknown | FK |
amount | Unknown | |
card_type | Unknown | |
category | Unknown | |
category_name | Unknown | |
check_in | Unknown | |
check_out | Unknown | |
currency | Unknown | |
date_time | Unknown | |
date_time_utc | Unknown | |
description | Unknown | |
is_deleted | Unknown | |
modified_date_time | Unknown | |
modified_date_time_utc | Unknown | |
notes | Unknown | |
parent_transaction_id | Unknown | |
quantity | Unknown | |
room_name | Unknown | |
transaction_category | Unknown | |
transaction_code | Unknown | |
type | Unknown | |
user_name | Unknown |
reservation_detail_rate_by_room
| Column | Type | Keys |
|---|---|---|
room_type_id | Unknown | PK |
reservation_id | Unknown | PKFK |
guest_id | Unknown | FK |
room_id | Unknown | FK |
detailed_room_rate_names | Json | |
rate_id | Unknown | |
rate_name | Unknown | |
room_status | Unknown |
reservation_detail_rate_by_day
| Column | Type | Keys |
|---|---|---|
rate_date | Unknown | PK |
reservation_id | Unknown | PKFK |
name | Unknown |
reservation_detail_rate
| Column | Type | Keys |
|---|---|---|
reservation_id | Unknown | PKFK |
guest_id | Unknown | FK |
balance_detailed_additional_items | Unknown | |
balance_detailed_grand_total | Unknown | |
balance_detailed_paid | Unknown | |
balance_detailed_sub_total | Unknown | |
balance_detailed_suggested_deposit | Unknown | |
balance_detailed_taxes_fees | Unknown | |
check_in | Unknown | |
check_out | Unknown | |
currency | Unknown | |
date_created | Unknown | |
date_created_utc | Unknown | |
date_modified | Unknown | |
date_modified_utc | Unknown | |
is_deleted | Unknown | |
source_category | Unknown | |
source_name | Unknown | |
source_payment_collect | Unknown |
blocked_room
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
room_block_id | Unknown | PKFK |
room_type_id | Unknown |
blocked
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | PK |
end_date | Unknown | |
reason | Unknown | |
start_date | Unknown | |
type | Unknown |
room_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | FK |
adults_included | Unknown | |
children_included | Unknown | |
description | Unknown | |
features | Json | |
is_private | Unknown | |
max_guests | Unknown | |
name_short | Unknown | |
photos | Json | |
room_rate | Unknown | |
room_type_name | Unknown | |
rooms_available | Unknown | |
type_units | Unknown |
guest_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
guest_id | Unknown | PKFK |
note | Unknown |
guest
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
property_id | Unknown | FK |
reservation_id | Unknown | FK |
address | Unknown | |
address_2 | Unknown | |
assigned_room | Unknown | |
birthdate | Unknown | |
cell_phone | Unknown | |
city | Unknown | |
company_name | Unknown | |
company_tax_id | Unknown | |
country | Unknown | |
document_expiration_date | Unknown | |
document_issue_date | Unknown | |
document_issuing_country | Unknown | |
document_number | Unknown | |
document_type | Unknown | |
email | Unknown | |
end_date | Unknown | |
first_name | Unknown | |
gender | Unknown | |
guest_opt_in | Unknown | |
is_anonymized | Unknown | |
is_main_guest | Unknown | |
is_merged | Unknown | |
last_name | Unknown | |
new_guest_id | Unknown | |
phone | Unknown | |
start_date | Unknown | |
state | Unknown | |
status | Unknown | |
tax_id | Unknown | |
zip | Unknown |
reservation_detail_guest
| Column | Type | Keys |
|---|---|---|
guest_id | Unknown | PKFK |
reservation_id | Unknown | PKFK |
room_id | Unknown | FK |
reservation_detail_of_room_assigned
| Column | Type | Keys |
|---|---|---|
reservation_id | Unknown | PKFK |
room_id | Unknown | PKFK |
adults | Unknown | |
children | Unknown | |
daily_rates | Json | |
end_date | Unknown | |
room_total | Unknown | |
start_date | Unknown |
reservation_detail_of_room_unassigned
| Column | Type | Keys |
|---|---|---|
room_type_id | Unknown | PK |
reservation_id | Unknown | PKFK |
room_id | Unknown | FK |
sub_reservation_id | Unknown |
reservation_detail_cards_on_file
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reservation_id | Unknown | PKFK |
reservation_detail_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
reservation_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
reservation_detail
| Column | Type | Keys |
|---|---|---|
reservation_id | Unknown | PKFK |
allotment_block_code | Unknown | FK |
source_id | Unknown | FK |
additional_items | Unknown | |
balance | Unknown | |
checkin_date | Unknown | |
checkout_date | Unknown | |
date_created | Unknown | |
date_modified | Unknown | |
grand_total | Unknown | |
order_id | Unknown | |
paid | Unknown | |
status | Unknown | |
sub_total | Unknown | |
suggested_deposit | Unknown | |
taxes_fees | Unknown | |
third_party_identifier | Unknown | |
total_booking_price | Unknown |
payment_allocation_reservation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payment_id | Unknown | PKFK |
amount | Unknown | |
name | Unknown | |
reference | Unknown | |
type | Unknown |
payment_reservation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
guest_id | Unknown | FK |
property_id | Unknown | FK |
reservation_id | Unknown | FK |
room_id | Unknown | FK |
transaction_id | Unknown | FK |
amount | Unknown | |
currency | Unknown | |
description | Unknown | |
guest_checkin | Unknown | |
guest_checkout | Unknown | |
is_allocated | Unknown | |
is_deleted | Unknown | |
is_posted | Unknown | |
is_voided | Unknown | |
method | Unknown | |
quantity | Unknown | |
state | Unknown | |
total_allocated | Unknown | |
total_unallocated | Unknown | |
user_id | Unknown | |
username | Unknown |
payment_allocation_guest
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payment_id | Unknown | PKFK |
amount | Unknown | |
name | Unknown | |
reference | Unknown | |
type | Unknown |
payment_guest
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
guest_id | Unknown | FK |
property_id | Unknown | FK |
transaction_id | Unknown | FK |
amount | Unknown | |
currency | Unknown | |
description | Unknown | |
is_allocated | Unknown | |
is_deleted | Unknown | |
is_posted | Unknown | |
is_voided | Unknown | |
method | Unknown | |
quantity | Unknown | |
state | Unknown | |
total_allocated | Unknown | |
total_unallocated | Unknown | |
user_id | Unknown | |
user_name | Unknown |