# Calendly schema ERD

Table and field reference for the Fivetran Calendly connector.

## Table & Field Reference

### activity_log_entry

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| action | Unknown |  |
| actor_alternative_identifier | Unknown |  |
| actor_display_name | Unknown |  |
| actor_group_name | Unknown |  |
| actor_group_role | Unknown |  |
| actor_group_uri | Unknown |  |
| actor_organization_role | Unknown |  |
| actor_organization_uri | Unknown |  |
| actor_type | Unknown |  |
| actor_uri | Unknown |  |
| details | Json |  |
| fully_qualified_name | Unknown |  |
| namespace | Unknown |  |
| occurred_at | Unknown |  |
| organization_uri | Unknown |  |

### user_availability_schedule_rule_interval

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_availability_schedule_rule_index | Unknown | PK, FK |
| user_availability_schedule_uri | Unknown | PK, FK |
| from_time | Unknown |  |
| to_time | Unknown |  |

### user_availability_schedule_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_availability_schedule_uri | Unknown | PK, FK |
| date | Unknown |  |
| type | Unknown |  |
| wday | Unknown |  |

### user_availability_schedule

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| user_uri | Unknown | FK |
| defaults | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |

### organization_invitation

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| user_uri | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| last_sent_at | Unknown |  |
| organization_uri | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### answer_choice

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| custom_question_name | Unknown | PK, FK |
| custom_question_position | Unknown | PK, FK |
| event_type_uri | Unknown | PK, FK |
| answer_choice | Unknown |  |

### custom_question

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| position | Unknown | PK |
| event_type_uri | Unknown | PK, FK |
| enabled | Unknown |  |
| include_other | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### event_type

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| profile_owner | Unknown | FK |
| active | Unknown |  |
| booking_method | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| description_html | Unknown |  |
| description_plain | Unknown |  |
| duration | Unknown |  |
| internal_note | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| pooling_type | Unknown |  |
| profile_name | Unknown |  |
| profile_type | Unknown |  |
| scheduling_url | Unknown |  |
| secret | Unknown |  |
| slug | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### routing_form_question_answer_choice

| Column | Type | Keys |
| --- | --- | --- |
| answer_choice | Unknown | PK |
| routing_form_question_uuid | Unknown | PK, FK |
| routing_form_uri | Unknown | PK, FK |

### routing_form_question

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| routing_form_uri | Unknown | PK, FK |
| name | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### routing_form

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| organization_uri | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### question_and_answer

| Column | Type | Keys |
| --- | --- | --- |
| position | Unknown | PK |
| event_invitee_uri | Unknown | PK, FK |
| answer | Unknown |  |
| question | Unknown |  |

### event_invitee

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| event_uri | Unknown | FK |
| cancel_reason | Unknown |  |
| cancel_url | Unknown |  |
| canceled_by | Unknown |  |
| canceler_type | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| new_invitee | Unknown |  |
| no_show_created_at | Unknown |  |
| no_show_uri | Unknown |  |
| old_invitee | Unknown |  |
| payment_amount | Unknown |  |
| payment_currency | Unknown |  |
| payment_external_id | Unknown |  |
| payment_provider | Unknown |  |
| payment_successful | Unknown |  |
| payment_terms | Unknown |  |
| reconfirmation_confirmed_at | Unknown |  |
| reconfirmation_created_at | Unknown |  |
| reschedule_url | Unknown |  |
| rescheduled | Unknown |  |
| status | Unknown |  |
| text_reminder_number | Unknown |  |
| timezone | Unknown |  |
| tracking_salesforce_uuid | Unknown |  |
| tracking_utm_campaign | Unknown |  |
| tracking_utm_content | Unknown |  |
| tracking_utm_medium | Unknown |  |
| tracking_utm_source | Unknown |  |
| tracking_utm_term | Unknown |  |
| updated_at | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| organization_membership_uri | Unknown | FK |
| avatar_url | Unknown |  |
| created_at | Unknown |  |
| current_organization | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| scheduling_url | Unknown |  |
| slug | Unknown |  |
| timezone | Unknown |  |
| updated_at | Unknown |  |

### organization_membership

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| created_at | Unknown |  |
| role | Unknown |  |
| updated_at | Unknown |  |

### event_type_availability_schedule_rule_interval

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_type_availability_schedule_rule_index | Unknown | PK, FK |
| event_type_availability_schedule_uri | Unknown | PK, FK |
| from_time | Unknown |  |
| to_time | Unknown |  |

### event_type_availability_schedule_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_type_availability_schedule_uri | Unknown | PK, FK |
| date | Unknown |  |
| type | Unknown |  |
| wday | Unknown |  |

### event_type_availability_schedule

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| event_type_uri | Unknown | FK |
| user_uri | Unknown | FK |
| availability_setting | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |

### event_guest

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| event_uri | Unknown | PK, FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### event_membership

| Column | Type | Keys |
| --- | --- | --- |
| event_uri | Unknown | PK, FK |
| user_uri | Unknown | PK, FK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| uri | Unknown | PK |
| event_type_uri | Unknown | FK |
| cancel_reason | Unknown |  |
| canceled_by | Unknown |  |
| canceler_type | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| invitees_active | Unknown |  |
| invitees_limit | Unknown |  |
| location | Unknown |  |
| location_additional_info | Unknown |  |
| location_extra | Unknown |  |
| location_id | Unknown |  |
| location_join_url | Unknown |  |
| location_password | Unknown |  |
| location_settings | Json |  |
| location_status | Unknown |  |
| location_type | Unknown |  |
| name | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- user_availability_schedule_rule_interval(user_availability_schedule_rule_index) → user_availability_schedule_rule(index)
- user_availability_schedule_rule_interval(user_availability_schedule_uri) → user_availability_schedule_rule(user_availability_schedule_uri)
- user_availability_schedule_rule(user_availability_schedule_uri) → user_availability_schedule(uri)
- user_availability_schedule(user_uri) → users(uri)
- organization_invitation(user_uri) → users(uri)
- answer_choice(event_type_uri) → event_type(uri)
- answer_choice(custom_question_name) → custom_question(name)
- answer_choice(custom_question_position) → custom_question(position)
- custom_question(event_type_uri) → event_type(uri)
- event_type(profile_owner) → users(uri)
- routing_form_question_answer_choice(routing_form_question_uuid) → routing_form_question(uuid)
- routing_form_question_answer_choice(routing_form_uri) → routing_form_question(routing_form_uri)
- routing_form_question(routing_form_uri) → routing_form(uri)
- question_and_answer(event_invitee_uri) → event_invitee(uri)
- event_invitee(event_uri) → event(uri)
- users(organization_membership_uri) → organization_membership(uri)
- event_type_availability_schedule_rule_interval(event_type_availability_schedule_rule_index) → event_type_availability_schedule_rule(index)
- event_type_availability_schedule_rule_interval(event_type_availability_schedule_uri) → event_type_availability_schedule_rule(event_type_availability_schedule_uri)
- event_type_availability_schedule_rule(event_type_availability_schedule_uri) → event_type_availability_schedule(uri)
- event_type_availability_schedule(user_uri) → users(uri)
- event_type_availability_schedule(event_type_uri) → event_type(uri)
- event_guest(event_uri) → event(uri)
- event_membership(user_uri) → users(uri)
- event_membership(event_uri) → event(uri)
- event(event_type_uri) → event_type(uri)