Cal.com

Explore the interactive ERD

Table & Field Reference

booking_host

Column	Type	Keys
`id`	Unknown	PK
`booking_uid`	Unknown	PKFK
`email`	Unknown
`name`	Unknown
`time_zone`	Unknown
`username`	Unknown

booking_attendee

Column	Type	Keys
`index`	Unknown	PK
`booking_uid`	Unknown	PKFK
`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	PKFK
`booking_uid`	Unknown	PKFK
`duration`	Unknown
`join_time`	Unknown
`user_name`	Unknown

booking_conferencing_session

Column	Type	Keys
`id`	Unknown	PK
`booking_uid`	Unknown	PKFK
`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	PKFK
`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	PKFK
`destination_calendar_id`	Unknown	FK
`event_uid`	Unknown
`type`	Unknown

event_type_booking_window

Column	Type	Keys
`index`	Unknown	PK
`event_type_id`	Unknown	PKFK
`rolling`	Unknown
`type`	Unknown
`value`	Unknown

event_type_booking_field

Column	Type	Keys
`index`	Unknown	PK
`event_type_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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