Splash

Explore the interactive ERD

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	PKFK
`count`	Unknown
`name`	Unknown

event_group

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`group_id`	Unknown

event_attendance_type

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`event_attendance_type`	Unknown

event_custom_question

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

event_locale

Column	Type	Keys
`code`	Unknown	PK
`event_id`	Unknown	PKFK
`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