# Cal.com schema ERD

Table and field reference for the Fivetran Cal.com connector.

## Table & Field Reference

### booking_host

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booking_uid | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| time_zone | Unknown |  |
| username | Unknown |  |

### booking_attendee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uid | Unknown | PK, FK |
| absent | Unknown |  |
| email | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| time_zone | Unknown |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| uid | Unknown | PK |
| event_type_id | Unknown | FK |
| absent_host | Unknown |  |
| booking_response_attendee_phone_number | Unknown |  |
| booking_response_company | Unknown |  |
| booking_response_display_guests | Json |  |
| booking_response_email | Unknown |  |
| booking_response_guests | Json |  |
| booking_response_location_option_value | Unknown |  |
| booking_response_location_value | Unknown |  |
| booking_response_name | Unknown |  |
| booking_response_notes | Unknown |  |
| booking_response_platform | Unknown |  |
| cancellation_reason | Unknown |  |
| cancelled_by_email | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| end_date | Unknown |  |
| event_type_slug | Unknown |  |
| ics_uid | Unknown |  |
| id | Unknown |  |
| location | Unknown |  |
| meeting_url | Unknown |  |
| metadata | Json |  |
| rating | Unknown |  |
| rescheduled_by_email | Unknown |  |
| rescheduled_from_uid | Unknown |  |
| rescheduled_to_uid | Unknown |  |
| rescheduling_reason | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |

### booking_conferencing_session_participant

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| booking_conferencing_session_id | Unknown | PK, FK |
| booking_uid | Unknown | PK, FK |
| duration | Unknown |  |
| join_time | Unknown |  |
| user_name | Unknown |  |

### booking_conferencing_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booking_uid | Unknown | PK, FK |
| destination_calendar_id | Unknown | FK |
| duration | Unknown |  |
| max_participant | Unknown |  |
| ongoing | Unknown |  |
| room | Unknown |  |
| start_time | Unknown |  |

### booking_recording

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booking_uid | Unknown | PK, FK |
| download_link | Unknown |  |
| duration | Unknown |  |
| error | Unknown |  |
| max_participant | Unknown |  |
| room_name | Unknown |  |
| share_token | Unknown |  |
| start_time_stamp | Unknown |  |
| status | Unknown |  |

### booking_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booking_uid | Unknown | PK, FK |
| destination_calendar_id | Unknown | FK |
| event_uid | Unknown |  |
| type | Unknown |  |

### event_type_booking_window

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_type_id | Unknown | PK, FK |
| rolling | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### event_type_booking_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_type_id | Unknown | PK, FK |
| disable_on_prefill | Unknown |  |
| is_default | Unknown |  |
| required | Unknown |  |
| slug | Unknown |  |
| type | Unknown |  |

### event_type_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_type_id | Unknown | PK, FK |
| avatar_url | Unknown |  |
| brand_color | Unknown |  |
| dark_brand_color | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| username | Unknown |  |
| week_start | Unknown |  |

### event_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| after_event_buffer | Unknown |  |
| allow_rescheduling_cancelled_booking | Unknown |  |
| allow_rescheduling_past_booking | Unknown |  |
| before_event_buffer | Unknown |  |
| booker_active_booking_limit_maximum_active_booking | Unknown |  |
| booker_active_booking_limit_offer_reschedule | Unknown |  |
| booker_active_bookings_limit_disabled | Unknown |  |
| booker_layouts | Json |  |
| booking_limits_count_day | Unknown |  |
| booking_limits_count_month | Unknown |  |
| booking_limits_count_week | Unknown |  |
| booking_limits_count_year | Unknown |  |
| booking_limits_duration_day | Unknown |  |
| booking_limits_duration_month | Unknown |  |
| booking_limits_duration_week | Unknown |  |
| booking_limits_duration_year | Unknown |  |
| booking_requires_authentication | Unknown |  |
| booking_url | Unknown |  |
| booking_window_disabled | Unknown |  |
| cal_video_settings_disable_recording_for_guests | Unknown |  |
| cal_video_settings_disable_recording_for_organizer | Unknown |  |
| cal_video_settings_disable_transcription_for_guests | Unknown |  |
| cal_video_settings_disable_transcription_for_organizer | Unknown |  |
| cal_video_settings_enable_automatic_recording_for_organizer | Unknown |  |
| cal_video_settings_enable_automatic_transcription | Unknown |  |
| cal_video_settings_redirect_url_on_exit | Unknown |  |
| cal_video_settings_send_transcription_email | Unknown |  |
| cal_video_settings_send_transcription_emails | Unknown |  |
| color | Json |  |
| confirmation_policy_disabled | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| destination_calendar_external_id | Unknown |  |
| destination_calendar_integration | Unknown |  |
| disable_cancelling_disabled | Unknown |  |
| disable_guest | Unknown |  |
| disable_rescheduling_disabled | Unknown |  |
| forward_params_success_redirect | Unknown |  |
| hidden | Unknown |  |
| hide_calendar_event_detail | Unknown |  |
| hide_calendar_note | Unknown |  |
| hide_organizer_email | Unknown |  |
| interface_language | Unknown |  |
| is_instant_event | Unknown |  |
| length_in_minutes | Unknown |  |
| length_in_minutes_options | Json |  |
| loaction_integration | Unknown |  |
| loaction_type | Unknown |  |
| lock_time_zone_toggle_on_booking_page | Unknown |  |
| metadata | Json |  |
| minimum_booking_notice | Unknown |  |
| offset_start | Unknown |  |
| only_show_first_available_slot | Unknown |  |
| owner_id | Unknown |  |
| price | Unknown |  |
| recurrence_frequency | Unknown |  |
| recurrence_interval | Unknown |  |
| recurrence_occurrence | Unknown |  |
| requires_booker_email_verification | Unknown |  |
| schedule_id | Unknown |  |
| seats_disabled | Unknown |  |
| seats_per_time_slot | Unknown |  |
| seats_seats_per_time_slot | Unknown |  |
| seats_show_attendee_info | Unknown |  |
| seats_show_availability_count | Unknown |  |
| show_optimized_slots | Unknown |  |
| slot_interval | Unknown |  |
| slug | Unknown |  |
| success_redirect_url | Unknown |  |
| title | Unknown |  |
| use_destination_calendar_email | Unknown |  |

### calendar_properties

| Column | Type | Keys |
| --- | --- | --- |
| external_id | Unknown | PK |
| calendar_credential_id | Unknown | PK, FK |
| email | Unknown |  |
| integration | Unknown |  |
| is_primary | Unknown |  |
| is_selected | Unknown |  |
| name | Unknown |  |
| read_only | Unknown |  |

### calendar

| Column | Type | Keys |
| --- | --- | --- |
| credential_id | Unknown | PK |
| delegation_credential_id | Unknown |  |
| integration_app_data | Json |  |
| integration_categories | Json |  |
| integration_delegation_credential_workspace_platform_slug | Unknown |  |
| integration_description | Unknown |  |
| integration_directory_name | Unknown |  |
| integration_email | Unknown |  |
| integration_installed | Unknown |  |
| integration_is_oauth | Unknown |  |
| integration_location_option_disabled | Unknown |  |
| integration_location_option_icon | Unknown |  |
| integration_location_option_label | Unknown |  |
| integration_location_option_value | Unknown |  |
| integration_logo | Unknown |  |
| integration_name | Unknown |  |
| integration_publisher | Unknown |  |
| integration_slug | Unknown |  |
| integration_template | Unknown |  |
| integration_title | Unknown |  |
| integration_type | Unknown |  |
| integration_url | Unknown |  |
| integration_variant | Unknown |  |
| primary_email | Unknown |  |
| primary_external_id | Unknown |  |
| primary_integration | Unknown |  |
| primary_is_primary | Unknown |  |
| primary_is_selected | Unknown |  |
| primary_name | Unknown |  |
| primary_read_only | Unknown |  |

### destination_calendar

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credential_id | Unknown | FK |
| event_type_id | Unknown | FK |
| created_at | Unknown |  |
| custom_calendar_reminder | Unknown |  |
| delegation_credential_id | Unknown |  |
| domain_wide_delegation_credential_id | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| integration | Unknown |  |
| integration_title | Unknown |  |
| is_primary | Unknown |  |
| is_selected | Unknown |  |
| name | Unknown |  |
| primary_email | Unknown |  |
| read_only | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |

## Relationships

- booking_host(booking_uid) → booking(uid)
- booking_attendee(booking_uid) → booking(uid)
- booking(event_type_id) → event_type(id)
- booking_conferencing_session_participant(booking_conferencing_session_id) → booking_conferencing_session(id)
- booking_conferencing_session_participant(booking_uid) → booking_conferencing_session(booking_uid)
- booking_conferencing_session(destination_calendar_id) → destination_calendar(id)
- booking_conferencing_session(booking_uid) → booking(uid)
- booking_recording(booking_uid) → booking(uid)
- booking_reference(destination_calendar_id) → destination_calendar(id)
- booking_reference(booking_uid) → booking(uid)
- event_type_booking_window(event_type_id) → event_type(id)
- event_type_booking_field(event_type_id) → event_type(id)
- event_type_user(event_type_id) → event_type(id)
- calendar_properties(calendar_credential_id) → calendar(credential_id)
- destination_calendar(credential_id) → calendar(credential_id)
- destination_calendar(event_type_id) → event_type(id)