# Google Calendar schema ERD

Table and field reference for the Fivetran Google Calendar connector.

## Table & Field Reference

### conference_data_entrypoint

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| access_code | Unknown |  |
| entrypoint_type | Unknown |  |
| label | Unknown |  |
| meeting_code | Unknown |  |
| passcode | Unknown |  |
| password | Unknown |  |
| pin | Unknown |  |
| uri | Unknown |  |

### reminder_override

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| method | Unknown |  |
| minutes | Unknown |  |

### attendee

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| event_id | Unknown | PK, FK |
| additional_guests | Unknown |  |
| comment | Unknown |  |
| display_name | Unknown |  |
| optional | Unknown |  |
| organizer | Unknown |  |
| resource | Unknown |  |
| response_status | Unknown |  |
| self | Unknown |  |

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| event_id | Unknown | FK |
| file_id | Unknown |  |
| file_url | Unknown |  |
| icon_link | Unknown |  |
| mime_type | Unknown |  |
| title | Unknown |  |

### recurrence

| Column | Type | Keys |
| --- | --- | --- |
| recurrence | Unknown | PK |
| event_id | Unknown | PK, FK |

### event_gadget_preference

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| value | Unknown |  |

### event_private_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| value | Unknown |  |

### event_shared_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| value | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calendar_list_id | Unknown | FK |
| recurring_event_id | Unknown | FK |
| anyone_can_add_self | Unknown |  |
| attendees_omitted | Unknown |  |
| conference_id | Unknown |  |
| conference_solution_type | Unknown |  |
| created | Unknown |  |
| creator_display_name | Unknown |  |
| creator_email | Unknown |  |
| creator_id | Unknown |  |
| creator_self | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| end_date_time | Unknown |  |
| end_time_unspecified | Unknown |  |
| end_time_zone | Unknown |  |
| etag | Unknown |  |
| event_type | Unknown |  |
| gadget_display | Unknown |  |
| gadget_height | Unknown |  |
| gadget_icon_link | Unknown |  |
| gadget_link | Unknown |  |
| gadget_title | Unknown |  |
| gadget_type | Unknown |  |
| gadget_width | Unknown |  |
| guests_can_invite_others | Unknown |  |
| guests_can_modify | Unknown |  |
| guests_can_see_other_guests | Unknown |  |
| hangout_link | Unknown |  |
| html_link | Unknown |  |
| i_cal_uid | Unknown |  |
| icon_uri | Unknown |  |
| kind | Unknown |  |
| location | Unknown |  |
| locked | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| organizer_display_name | Unknown |  |
| organizer_email | Unknown |  |
| organizer_id | Unknown |  |
| organizer_self | Unknown |  |
| original_start_date | Unknown |  |
| original_start_time_date | Unknown |  |
| original_start_time_zone | Unknown |  |
| private_copy | Unknown |  |
| request_id | Unknown |  |
| sequence | Unknown |  |
| signature | Unknown |  |
| start_date | Unknown |  |
| start_date_time | Unknown |  |
| start_time_zone | Unknown |  |
| status | Unknown |  |
| status_code | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |
| transparency | Unknown |  |
| type | Unknown |  |
| updated | Instant |  |
| url | Unknown |  |
| use_default | Unknown |  |
| visibility | Unknown |  |

### access_control_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calendar_list_id | Unknown | FK |
| etag | Unknown |  |
| kind | Unknown |  |
| role | Unknown |  |
| scope_type | Unknown |  |
| scope_value | Unknown |  |

### setting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| etag | Unknown |  |
| kind | Unknown |  |
| value | Unknown |  |

### default_reminder

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| calendar_list_id | Unknown | FK |
| method | Unknown |  |
| minutes | Unknown |  |

### allowed_conference_solution_type

| Column | Type | Keys |
| --- | --- | --- |
| solution_type | Unknown | PK |
| calendar_list_id | Unknown | PK, FK |

### notification_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| calendar_list_id | Unknown | FK |
| method | Unknown |  |
| type | Unknown |  |

### calendar_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| access_role | Unknown |  |
| background_color | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| etag | Unknown |  |
| foreground_color | Unknown |  |
| hidden | Unknown |  |
| is_primary | Unknown |  |
| kind | Unknown |  |
| location | Unknown |  |
| selected | Unknown |  |
| summary | Unknown |  |
| summary_override | Unknown |  |
| time_zone | Unknown |  |

## Relationships

- conference_data_entrypoint(event_id) → event(id)
- reminder_override(event_id) → event(id)
- attendee(event_id) → event(id)
- attachment(event_id) → event(id)
- recurrence(event_id) → event(id)
- event_gadget_preference(event_id) → event(id)
- event_private_property(event_id) → event(id)
- event_shared_property(event_id) → event(id)
- event(recurring_event_id) → event(id)
- event(calendar_list_id) → calendar_list(id)
- access_control_list(calendar_list_id) → calendar_list(id)
- default_reminder(calendar_list_id) → calendar_list(id)
- allowed_conference_solution_type(calendar_list_id) → calendar_list(id)
- notification_setting(calendar_list_id) → calendar_list(id)