# Cloudbeds schema ERD

Table and field reference for the Fivetran Cloudbeds connector.

## 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 | PK, FK |
| amount | Unknown |  |
| amount_type | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### source_fee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| source_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |

### reservation_detail_rate

| Column | Type | Keys |
| --- | --- | --- |
| reservation_id | Unknown | PK, FK |
| 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 | PK, FK |
| room_block_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| reservation_id | Unknown | PK, FK |
| room_id | Unknown | FK |

### reservation_detail_of_room_assigned

| Column | Type | Keys |
| --- | --- | --- |
| reservation_id | Unknown | PK, FK |
| room_id | Unknown | PK, FK |
| 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 | PK, FK |
| room_id | Unknown | FK |
| sub_reservation_id | Unknown |  |

### reservation_detail_cards_on_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reservation_id | Unknown | PK, FK |

### reservation_detail_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| reservation_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### reservation_detail

| Column | Type | Keys |
| --- | --- | --- |
| reservation_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- house_account(property_id) → hotel(id)
- source_tax(source_id) → source_property(id)
- source_fee(source_id) → source_property(id)
- source_property(property_id) → hotel(id)
- hotel_detail(id) → hotel(id)
- custom_field(property_id) → hotel(id)
- payment_allocation_house(payment_id) → payment_house(id)
- payment_house(room_id) → room(id)
- payment_house(property_id) → hotel(id)
- payment_house(house_account_id) → house_account(id)
- payment_house(reservation_id) → reservation(reservation_id)
- payment_house(guest_id) → guest(id)
- payment_house(transaction_id) → transaction(transaction_id)
- allotment_interval(room_type_id) → room_type(id)
- allotment_interval(allotment_block_id) → allotment_block(id)
- allotment_block(property_id) → hotel(id)
- room(room_type_id) → room_type(id)
- reservation(property_id) → hotel(id)
- transaction(room_type_id) → room_type(id)
- transaction(property_id) → hotel(id)
- transaction(house_account_id) → house_account(id)
- transaction(reservation_id) → reservation(reservation_id)
- transaction(guest_id) → guest(id)
- reservation_detail_rate_by_room(room_id) → room(id)
- reservation_detail_rate_by_room(guest_id) → guest(id)
- reservation_detail_rate_by_room(reservation_id) → reservation_detail_rate(reservation_id)
- reservation_detail_rate_by_day(reservation_id) → reservation_detail_rate(reservation_id)
- reservation_detail_rate(reservation_id) → reservation(reservation_id)
- reservation_detail_rate(guest_id) → guest(id)
- blocked_room(id) → room(id)
- blocked_room(room_block_id) → blocked(id)
- room_type(property_id) → hotel(id)
- guest_note(guest_id) → guest(id)
- guest(property_id) → hotel(id)
- guest(reservation_id) → reservation(reservation_id)
- reservation_detail_guest(guest_id) → guest(id)
- reservation_detail_guest(reservation_id) → reservation(reservation_id)
- reservation_detail_guest(room_id) → room(id)
- reservation_detail_of_room_assigned(room_id) → room(id)
- reservation_detail_of_room_assigned(reservation_id) → reservation_detail(reservation_id)
- reservation_detail_of_room_unassigned(room_id) → room_type(id)
- reservation_detail_of_room_unassigned(reservation_id) → reservation_detail(reservation_id)
- reservation_detail_cards_on_file(reservation_id) → reservation_detail(reservation_id)
- reservation_detail_custom_field(reservation_id) → reservation_detail(reservation_id)
- reservation_detail(allotment_block_code) → allotment_block(id)
- reservation_detail(reservation_id) → reservation(reservation_id)
- reservation_detail(source_id) → source_property(id)
- payment_allocation_reservation(payment_id) → payment_reservation(id)
- payment_reservation(room_id) → room(id)
- payment_reservation(property_id) → hotel(id)
- payment_reservation(reservation_id) → reservation(reservation_id)
- payment_reservation(guest_id) → guest(id)
- payment_reservation(transaction_id) → transaction(transaction_id)
- payment_allocation_guest(payment_id) → payment_guest(id)
- payment_guest(property_id) → hotel(id)
- payment_guest(guest_id) → guest(id)
- payment_guest(transaction_id) → transaction(transaction_id)