# Splash schema ERD

Table and field reference for the Fivetran Splash connector.

## Table & Field Reference

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar_url | Unknown |  |
| birthday | Unknown |  |
| bounced | Unknown |  |
| city | Unknown |  |
| create_date | Unknown |  |
| deleted | Unknown |  |
| facebook_display_name | Unknown |  |
| facebook_url | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| instagram_display_name | Unknown |  |
| instagram_url | Unknown |  |
| invalid_email | Unknown |  |
| last_name | Unknown |  |
| linkedin_display_name | Unknown |  |
| linkedin_url | Unknown |  |
| middle_name | Unknown |  |
| modify_date | Unknown |  |
| notes | Unknown |  |
| organization_name | Unknown |  |
| phone | Unknown |  |
| pinterest_display_name | Unknown |  |
| pinterest_url | Unknown |  |
| primary_email | Unknown |  |
| profile_image | Unknown |  |
| salesforce_id | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| title | Unknown |  |
| twitter_display_name | Unknown |  |
| twitter_url | Unknown |  |
| unsubscribed | Unknown |  |
| vip | Unknown |  |
| website | Unknown |  |
| zip | Unknown |  |

### event_stats

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| count | Unknown |  |
| name | Unknown |  |

### event_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| group_id | Unknown |  |

### event_attendance_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| event_attendance_type | Unknown |  |

### event_custom_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| column_name | Unknown |  |
| custom_question_id | Unknown |  |
| deleted | Unknown |  |
| external_link | Unknown |  |
| name | Unknown |  |
| protected | Unknown |  |
| required | Unknown |  |
| selected_value | Json |  |
| type | Unknown |  |
| values | Json |  |

### event_triggered_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| active | Unknown |  |
| content | Unknown |  |
| event_message_id | Unknown |  |
| event_message_linked_to_theme | Unknown |  |
| event_ticket_type_id | Unknown |  |
| include_calendar_attachment | Unknown |  |
| include_pdf_attachment | Unknown |  |
| pdf_content | Unknown |  |
| subject | Unknown |  |
| trigger | Unknown |  |
| use_default_confirmation | Unknown |  |

### group_contact_answer

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| group_contact_id | Unknown | PK, FK |
| answer | Unknown |  |

### group_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| event_id | Unknown | FK |
| event_rsvp_contact_id | Unknown | FK |
| created | Unknown |  |
| deleted | Unknown |  |
| event_list | Unknown |  |
| event_rsvp_id | Unknown |  |
| modified | Unknown |  |
| salesforce_campaign_member_id | Unknown |  |
| status | Unknown |  |

### organization_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| child_group_id | Unknown |  |
| title | Unknown |  |

### event_multi_currency_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| code | Unknown |  |
| name | Unknown |  |

### event_locale

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

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type_id | Unknown | PK |
| allow_vep_url_sharing | Unknown |  |
| autosave | Unknown |  |
| button_closed_message | Unknown |  |
| cached_maps_square | Unknown |  |
| cached_maps_wide | Unknown |  |
| card | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| custom_domain | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| description_text | Unknown |  |
| domain | Unknown |  |
| email_settings_google_map_url | Unknown |  |
| email_white_label_key | Unknown |  |
| end | Unknown |  |
| end_time | Unknown |  |
| facebook_description | Unknown |  |
| facebook_title | Unknown |  |
| favicon_url | Unknown |  |
| form_email_domain_restriction | Unknown |  |
| form_is_in_library | Unknown |  |
| fq_url | Unknown |  |
| has_event_sold_or_pending_tickets | Unknown |  |
| has_event_sold_tickets | Unknown |  |
| has_virtual | Unknown |  |
| hashtag | Unknown |  |
| header_image | Unknown |  |
| hide_event_time | Unknown |  |
| hide_footer | Unknown |  |
| host | Unknown |  |
| hub | Unknown |  |
| invite_link_privacy_bypass | Unknown |  |
| is_invite_only | Unknown |  |
| is_rsvp_open | Unknown |  |
| lat | Unknown |  |
| limit_one_order_per_email | Unknown |  |
| limit_one_per_email | Unknown |  |
| limit_one_ticket_type_per_email | Unknown |  |
| linkedin_description | Unknown |  |
| linkedin_title | Unknown |  |
| lng | Unknown |  |
| locale | Unknown |  |
| meta_calendar_description | Unknown |  |
| meta_description | Unknown |  |
| meta_robots_txt | Unknown |  |
| meta_sitemap_xml | Unknown |  |
| meta_title | Unknown |  |
| mobile_check_in_url | Unknown |  |
| mobility_account_id | Unknown |  |
| mobility_wholesaler_id | Unknown |  |
| modified_at | Unknown |  |
| multisession | Unknown |  |
| no_index | Unknown |  |
| organization | Unknown |  |
| owner_email | Unknown |  |
| owner_first_name | Unknown |  |
| owner_last_name | Unknown |  |
| page_action | Unknown |  |
| page_password | Unknown |  |
| page_privacy_type | Unknown |  |
| paid_for_domain | Unknown |  |
| published | Unknown |  |
| redirect_to | Unknown |  |
| registration_updating_deadline | Unknown |  |
| registration_updating_enabled | Unknown |  |
| require_captcha | Unknown |  |
| rsvp_closed_at | Unknown |  |
| rsvp_closed_state | Unknown |  |
| rsvp_closed_team_notified | Unknown |  |
| rsvp_guest_display | Unknown |  |
| rsvp_max | Unknown |  |
| rsvp_method | Unknown |  |
| rsvp_open | Unknown |  |
| salesforce_campaign_id | Unknown |  |
| send_guest_confirmation | Unknown |  |
| sessions_overlap | Unknown |  |
| setting_id | Unknown |  |
| share_image_url | Unknown |  |
| splash_hub_auto_subscribe | Unknown |  |
| splash_theme_abbr | Unknown |  |
| splash_theme_active | Unknown |  |
| splash_theme_created | Unknown |  |
| splash_theme_id | Unknown |  |
| splash_theme_image_url | Unknown |  |
| splash_theme_name | Unknown |  |
| splash_theme_sort | Unknown |  |
| splash_theme_thumbnail_url | Unknown |  |
| stages | Unknown |  |
| start | Unknown |  |
| start_time | Unknown |  |
| state | Unknown |  |
| statistics | Unknown |  |
| status | Unknown |  |
| tags | Unknown |  |
| ticket_types | Unknown |  |
| time_zone | Unknown |  |
| time_zone_id | Unknown |  |
| title | Unknown |  |
| twitter_default | Unknown |  |
| type | Unknown |  |
| users | Unknown |  |
| vat_setting | Unknown |  |
| venue_address | Unknown |  |
| venue_city | Unknown |  |
| venue_country | Unknown |  |
| venue_lat | Unknown |  |
| venue_lon | Unknown |  |
| venue_name | Unknown |  |
| venue_postal_code | Unknown |  |
| venue_region | Unknown |  |
| venue_tbd | Unknown |  |
| wait_list | Unknown |  |
| waitlist_settings | Unknown |  |
| white_label | Unknown |  |
| workflow | Unknown |  |
| zip_code | Unknown |  |

## Relationships

- event_stats(event_id) → event(id)
- event_group(event_id) → event(id)
- event_attendance_type(event_id) → event(id)
- event_custom_question(event_id) → event(id)
- event_triggered_email(event_id) → event(id)
- group_contact_answer(group_contact_id) → group_contact(id)
- group_contact(event_id) → event(id)
- group_contact(contact_id) → contact(id)
- group_contact(event_rsvp_contact_id) → contact(id)
- event_multi_currency_option(event_id) → event(id)
- event_locale(event_id) → event(id)