# Goldcast schema ERD

Table and field reference for the Fivetran Goldcast connector.

## Table & Field Reference

### ticket_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| allow_all_tracks | Unknown |  |
| category_name | Unknown |  |
| category_ref_id | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| label | Unknown |  |
| member_count | Unknown |  |
| ticket_type_id | Unknown |  |
| updated_at | Unknown |  |

### broadcast_speaker

| Column | Type | Keys |
| --- | --- | --- |
| broadcast_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| speaker_id | Unknown | PK, FK |

### broadcast_video_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| broadcast_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| asset_type | Unknown |  |
| client_hls_path | Unknown |  |
| created_at | Unknown |  |
| created_by_email | Unknown |  |
| created_by_first_name | Unknown |  |
| created_by_id | Unknown |  |
| created_by_last_name | Unknown |  |
| created_by_organization | Unknown |  |
| created_by_profile_picture_url | Unknown |  |
| created_by_role | Unknown |  |
| creation_type | Unknown |  |
| deleted | Unknown |  |
| deleted_by_cascade | Unknown |  |
| duration | Unknown |  |
| embedded_url | Unknown |  |
| fallback_hls_path | Unknown |  |
| hls_path | Unknown |  |
| hls_url | Json |  |
| metadata | Json |  |
| name | Unknown |  |
| onedrive_file_id | Unknown |  |
| onedrive_upload_state | Unknown |  |
| organization | Unknown |  |
| path | Unknown |  |
| source | Unknown |  |
| thumbnail | Unknown |  |
| transcode_finish_time | Unknown |  |
| transcode_status | Unknown |  |
| transcoder_error | Json |  |
| transcoder_warning | Json |  |
| transcript_path | Json |  |
| updated_at | Unknown |  |
| updated_by_email | Unknown |  |
| updated_by_first_name | Unknown |  |
| updated_by_id | Unknown |  |
| updated_by_last_name | Unknown |  |
| updated_by_organization | Unknown |  |
| updated_by_profile_picture_url | Unknown |  |
| updated_by_role | Unknown |  |
| uploaded | Unknown |  |
| video_usage_count | Unknown |  |
| workspace | Unknown |  |

### broadcast

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| id | Unknown | PK |
| organization | Unknown | FK |
| allowed_end_time | Unknown |  |
| allowed_start_time | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| deleted_by_cascade | Unknown |  |
| end_time | Unknown |  |
| expected_end_time | Unknown |  |
| have_polls | Unknown |  |
| manual_redirection_enabled | Unknown |  |
| medialive_rtmp_input_channel_id | Unknown |  |
| medialive_rtmp_input_channel_states | Unknown |  |
| medialive_rtmp_input_created_at | Unknown |  |
| medialive_rtmp_input_event_id | Unknown |  |
| medialive_rtmp_input_failover_in_stream_key | Unknown |  |
| medialive_rtmp_input_failover_input_url | Unknown |  |
| medialive_rtmp_input_id | Unknown |  |
| medialive_rtmp_input_in_stream_key | Unknown |  |
| medialive_rtmp_input_input_frame_rate_alarm_state | Unknown |  |
| medialive_rtmp_input_input_frame_rate_alert_sent | Unknown |  |
| medialive_rtmp_input_input_url | Unknown |  |
| medialive_rtmp_input_name | Unknown |  |
| medialive_rtmp_input_network_in_alarm_state | Unknown |  |
| medialive_rtmp_input_network_in_alert_sent | Unknown |  |
| medialive_rtmp_input_output_url | Unknown |  |
| medialive_rtmp_input_test_run_end_time | Unknown |  |
| medialive_rtmp_input_updated_at | Unknown |  |
| mmid | Unknown |  |
| on_demand_asset_asset_type | Unknown |  |
| on_demand_asset_client_hls_path | Unknown |  |
| on_demand_asset_created_at | Unknown |  |
| on_demand_asset_created_by | Unknown |  |
| on_demand_asset_creation_type | Unknown |  |
| on_demand_asset_deleted | Unknown |  |
| on_demand_asset_deleted_by_cascade | Unknown |  |
| on_demand_asset_duration | Unknown |  |
| on_demand_asset_embedded_url | Unknown |  |
| on_demand_asset_fallback_hls_path | Unknown |  |
| on_demand_asset_hls_path | Unknown |  |
| on_demand_asset_id | Unknown |  |
| on_demand_asset_metadata | Json |  |
| on_demand_asset_name | Unknown |  |
| on_demand_asset_onedrive_file_id | Unknown |  |
| on_demand_asset_onedrive_upload_state | Unknown |  |
| on_demand_asset_organization | Unknown |  |
| on_demand_asset_path | Unknown |  |
| on_demand_asset_source | Unknown |  |
| on_demand_asset_thumbnail | Unknown |  |
| on_demand_asset_transcode_finish_time | Unknown |  |
| on_demand_asset_transcode_status | Unknown |  |
| on_demand_asset_transcoder_errors | Json |  |
| on_demand_asset_transcoder_type | Unknown |  |
| on_demand_asset_transcoder_warnings | Json |  |
| on_demand_asset_transcript_path | Unknown |  |
| on_demand_asset_updated_at | Unknown |  |
| on_demand_asset_updated_by | Unknown |  |
| on_demand_asset_uploaded | Unknown |  |
| on_demand_asset_urls | Unknown |  |
| on_demand_asset_video_usage_count | Unknown |  |
| on_demand_asset_workspace | Unknown |  |
| recording_individual_directory | Unknown |  |
| recording_individual_resource_id | Unknown |  |
| recording_individual_sid | Unknown |  |
| recording_mix_directory | Unknown |  |
| recording_mix_resource_id | Unknown |  |
| recording_mix_sid | Unknown |  |
| recording_video_asset_asset_type | Unknown |  |
| recording_video_asset_client_hls_path | Unknown |  |
| recording_video_asset_created_at | Unknown |  |
| recording_video_asset_created_by | Unknown |  |
| recording_video_asset_creation_type | Unknown |  |
| recording_video_asset_deleted | Unknown |  |
| recording_video_asset_deleted_by_cascade | Unknown |  |
| recording_video_asset_duration | Unknown |  |
| recording_video_asset_embedded_url | Unknown |  |
| recording_video_asset_fallback_hls_path | Unknown |  |
| recording_video_asset_hls_path | Unknown |  |
| recording_video_asset_id | Unknown |  |
| recording_video_asset_metadata | Json |  |
| recording_video_asset_name | Unknown |  |
| recording_video_asset_onedrive_file_id | Unknown |  |
| recording_video_asset_onedrive_upload_state | Unknown |  |
| recording_video_asset_organization | Unknown |  |
| recording_video_asset_path | Unknown |  |
| recording_video_asset_source | Unknown |  |
| recording_video_asset_thumbnail | Unknown |  |
| recording_video_asset_transcode_finish_time | Unknown |  |
| recording_video_asset_transcode_status | Unknown |  |
| recording_video_asset_transcoder_errors | Json |  |
| recording_video_asset_transcoder_type | Unknown |  |
| recording_video_asset_transcoder_warnings | Json |  |
| recording_video_asset_transcript_path | Unknown |  |
| recording_video_asset_updated_at | Unknown |  |
| recording_video_asset_updated_by | Unknown |  |
| recording_video_asset_uploaded | Unknown |  |
| recording_video_asset_urls | Unknown |  |
| recording_video_asset_video_usage_count | Unknown |  |
| recording_video_asset_workspace | Unknown |  |
| resources | Json |  |
| staffs | Json |  |
| start_time | Unknown |  |
| surveys | Json |  |
| ticker_url | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### tag_library

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization | Unknown | FK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| tag_name | Unknown |  |
| updated_by | Unknown |  |

### event_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| track_id | Unknown | FK |
| created_at | Unknown |  |
| event_role | Unknown |  |
| event_role_list | Json |  |
| external_demo_requested | Unknown |  |
| external_demo_requested_at | Unknown |  |
| kind | Json |  |
| magic_link | Unknown |  |
| marketo_lead_id | Unknown |  |
| organization_user_address_line_2 | Unknown |  |
| organization_user_age | Unknown |  |
| organization_user_allow_admin_panel_notifications | Unknown |  |
| organization_user_city | Unknown |  |
| organization_user_company | Unknown |  |
| organization_user_country | Unknown |  |
| organization_user_created_at | Unknown |  |
| organization_user_description | Unknown |  |
| organization_user_extra_data | Json |  |
| organization_user_first_name | Unknown |  |
| organization_user_id | Unknown |  |
| organization_user_industry | Unknown |  |
| organization_user_last_name | Unknown |  |
| organization_user_linkedin_url | Unknown |  |
| organization_user_location | Unknown |  |
| organization_user_organization | Unknown |  |
| organization_user_phone_number | Unknown |  |
| organization_user_profile_picture_url | Unknown |  |
| organization_user_state | Unknown |  |
| organization_user_street_address | Unknown |  |
| organization_user_title | Unknown |  |
| organization_user_twitter_url | Unknown |  |
| organization_user_updated_at | Unknown |  |
| organization_user_user | Unknown |  |
| organization_user_zip_code | Unknown |  |
| qrcode | Unknown |  |
| qrcode_encoding | Unknown |  |
| salesforce_member_id | Unknown |  |
| updated_at | Unknown |  |
| user_address_line_2 | Unknown |  |
| user_age | Unknown |  |
| user_allow_admin_panel_notifications | Unknown |  |
| user_city | Unknown |  |
| user_company | Unknown |  |
| user_country | Unknown |  |
| user_description | Unknown |  |
| user_display_email | Unknown |  |
| user_email | Unknown |  |
| user_extra_data | Unknown |  |
| user_first_name | Unknown |  |
| user_id | Unknown |  |
| user_industry | Unknown |  |
| user_is_admin | Unknown |  |
| user_is_content_lab_standalone | Unknown |  |
| user_is_registered | Unknown |  |
| user_last_name | Unknown |  |
| user_linkedin_url | Unknown |  |
| user_location | Unknown |  |
| user_mmid | Unknown |  |
| user_organization | Unknown |  |
| user_phone_number | Unknown |  |
| user_profile_picture_url | Unknown |  |
| user_requester_role | Unknown |  |
| user_role | Unknown |  |
| user_state | Unknown |  |
| user_street_address | Unknown |  |
| user_title | Unknown |  |
| user_twitter_url | Unknown |  |
| user_zip_code | Unknown |  |
| uuid | Unknown |  |
| vivenu_ticket_url | Unknown |  |

### resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| content_object | Unknown |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| key_or_url | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| s_3_hosted | Unknown |  |
| updated_at | Unknown |  |

### event_speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| company | Unknown |  |
| description | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| linkedin_url | Unknown |  |
| profile_picture_url | Unknown |  |
| title | Unknown |  |
| twitter_url | Unknown |  |

### booth_discussion_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booth_id | Unknown | PK, FK |
| event_id | Unknown | FK |
| capacity | Unknown |  |
| created_at | Unknown |  |
| current | Unknown |  |
| deleted | Unknown |  |
| deleted_by_cascade | Unknown |  |
| description | Unknown |  |
| ends_at | Unknown |  |
| is_booth | Unknown |  |
| is_breakout | Unknown |  |
| is_live | Unknown |  |
| mmid | Unknown |  |
| moderator | Json |  |
| owner | Unknown |  |
| participants | Json |  |
| rank | Unknown |  |
| recording_directory | Unknown |  |
| recording_resource_id | Unknown |  |
| recording_sid | Unknown |  |
| shadow_mmid | Unknown |  |
| sponsor_image | Unknown |  |
| starts_at | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| video_quality | Unknown |  |

### booth_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booth_id | Unknown | PK, FK |
| event_id | Unknown | FK |
| content_object | Unknown |  |
| content_type | Unknown |  |
| created_at | Unknown |  |
| key_or_url | Unknown |  |
| name | Unknown |  |
| object_id | Unknown |  |
| s_3_hosted | Unknown |  |
| updated_at | Unknown |  |

### booth

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| booth_type | Unknown |  |
| cover_image | Unknown |  |
| description | Unknown |  |
| hyperlink | Unknown |  |
| logo | Unknown |  |
| title | Unknown |  |

### agenda_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| allowed_end_time | Unknown |  |
| allowed_start_time | Unknown |  |
| description | Unknown |  |
| end_time | Unknown |  |
| expected_end_time | Unknown |  |
| is_live | Unknown |  |
| kind | Unknown |  |
| live_end_time | Unknown |  |
| live_start_time | Unknown |  |
| start_time | Unknown |  |
| title | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_hybrid_events | Unknown |  |
| can_add_track | Unknown |  |
| can_change_event_length | Unknown |  |
| can_create_rtmp_broadcast | Unknown |  |
| content_clips_count | Unknown |  |
| content_lab_enabled | Unknown |  |
| content_video_duration | Unknown |  |
| created_at | Unknown |  |
| enable_live_captions | Unknown |  |
| enable_old_reg_pages | Unknown |  |
| enabled_rtmp_out | Unknown |  |
| in_person_events_enabled | Unknown |  |
| is_booths_tab_enabled | Unknown |  |
| is_content_lab_standalone | Unknown |  |
| is_kudo_enabled | Unknown |  |
| is_ux_translation_enabled | Unknown |  |
| is_webhook_enabled | Unknown |  |
| name | Unknown |  |
| no_of_organizer_seats | Unknown |  |
| owner | Unknown |  |
| short_name | Unknown |  |
| show_advanced_branding_tab | Unknown |  |
| show_forms | Unknown |  |
| show_secondary_booth_tab | Unknown |  |
| tier | Unknown |  |
| updated_at | Unknown |  |
| use_new_studio_app | Unknown |  |
| workspace_settings_count | Unknown |  |

### event_public_agenda_session_speaker

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| session_id | Unknown | PK, FK |

### event_public_agenda

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| session_description | Unknown |  |
| session_end_time | Unknown |  |
| session_location | Unknown |  |
| session_name | Unknown |  |
| session_start_time | Unknown |  |
| session_type | Unknown |  |

### track_allowed_ticket_type

| Column | Type | Keys |
| --- | --- | --- |
| ticket_type_id | Unknown | PK, FK |
| track_id | Unknown | PK, FK |

### track

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| agenda_items | Unknown |  |
| channel_mmid | Unknown |  |
| created_at | Unknown |  |
| custom | Unknown |  |
| sort_priority | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### event_supported_language

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

### event_form_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| checked | Unknown |  |
| custom_validation_regex | Unknown |  |
| error | Unknown |  |
| error_message | Unknown |  |
| is_standard | Unknown |  |
| mapped_title | Unknown |  |
| optional | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization | Unknown | FK |
| broadcast_filler_image_s_3_path | Unknown |  |
| broadcast_filler_video_s_3_path | Unknown |  |
| broadcast_type | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| created_by_user_first_name | Unknown |  |
| created_by_user_id | Unknown |  |
| created_by_user_last_name | Unknown |  |
| created_by_user_organization | Unknown |  |
| created_by_user_profile_picture_url | Unknown |  |
| created_by_user_role | Unknown |  |
| default_language_dropdown_enabled | Unknown |  |
| deleted | Unknown |  |
| deleted_by_cascade | Unknown |  |
| end_time | Unknown |  |
| event_type | Unknown |  |
| integration_config_updated_salesforce | Unknown |  |
| is_blueprint | Unknown |  |
| is_hybrid | Unknown |  |
| manual_breakout | Unknown |  |
| meta_tag | Json |  |
| owner | Unknown |  |
| recording_state | Unknown |  |
| registrant_count | Unknown |  |
| registration_cta_link | Unknown |  |
| registration_form_form_type | Unknown |  |
| registration_form_id | Unknown |  |
| registration_form_is_default | Unknown |  |
| registration_form_is_global_form | Unknown |  |
| registration_form_is_one_click_enabled | Unknown |  |
| registration_form_name | Unknown |  |
| registration_form_organization | Unknown |  |
| registration_form_schema_url | Unknown |  |
| series_attendee_count | Unknown |  |
| series_blueprint_event | Unknown |  |
| series_builder_html | Unknown |  |
| series_builder_raw_json | Unknown |  |
| series_contains_waitlist_event | Unknown |  |
| series_created_at | Unknown |  |
| series_created_by | Unknown |  |
| series_description | Unknown |  |
| series_email_alias_name | Unknown |  |
| series_end_date_threshold | Unknown |  |
| series_favicon | Unknown |  |
| series_frequency | Unknown |  |
| series_id | Unknown |  |
| series_initial_event_generated | Unknown |  |
| series_initial_event_generation_count | Unknown |  |
| series_last_synced_at | Unknown |  |
| series_marketing_tags | Unknown |  |
| series_marketo_base_program_id | Unknown |  |
| series_marketo_program_folder_id | Unknown |  |
| series_marketo_program_folder_name | Unknown |  |
| series_marketo_settings | Unknown |  |
| series_marketo_status | Unknown |  |
| series_name | Unknown |  |
| series_next_event_generation_time | Unknown |  |
| series_organization | Unknown |  |
| series_parent | Unknown |  |
| series_registrant_count | Unknown |  |
| series_registration_form | Unknown |  |
| series_registration_form_data | Unknown |  |
| series_registration_form_form_type | Unknown |  |
| series_registration_form_id | Unknown |  |
| series_registration_form_is_default | Unknown |  |
| series_registration_form_is_global_form | Unknown |  |
| series_registration_form_is_one_click_enabled | Unknown |  |
| series_registration_form_name | Unknown |  |
| series_registration_form_organization | Unknown |  |
| series_registration_form_schema_url | Unknown |  |
| series_registration_form_url | Unknown |  |
| series_repeating_event_sync_allowed | Unknown |  |
| series_schedule | Unknown |  |
| series_schedule_status | Json |  |
| series_social_media_image | Unknown |  |
| series_sync_id | Unknown |  |
| series_sync_status | Unknown |  |
| series_tags | Json |  |
| series_total_event_threshold | Unknown |  |
| series_type | Unknown |  |
| series_unit | Unknown |  |
| series_upcoming_event_count | Unknown |  |
| series_updated_at | Unknown |  |
| series_updated_by | Unknown |  |
| series_url | Unknown |  |
| series_workspace | Unknown |  |
| short_id | Unknown |  |
| splash_tracking_pixel_snippet_body_section_script | Unknown |  |
| splash_tracking_pixel_snippet_created_at | Unknown |  |
| splash_tracking_pixel_snippet_created_by | Unknown |  |
| splash_tracking_pixel_snippet_custom_event_script | Unknown |  |
| splash_tracking_pixel_snippet_head_section_script | Unknown |  |
| splash_tracking_pixel_snippet_id | Unknown |  |
| splash_tracking_pixel_snippet_updated_at | Unknown |  |
| splash_tracking_pixel_snippet_updated_by | Unknown |  |
| start_time | Unknown |  |
| supported_captions_languages | Json |  |
| theme_alt_primary_background_shade | Unknown |  |
| theme_auth_theme | Unknown |  |
| theme_ctrl_bar_shade_alpha | Unknown |  |
| theme_event_background | Unknown |  |
| theme_font_link | Unknown |  |
| theme_font_name | Unknown |  |
| theme_font_src | Unknown |  |
| theme_font_type | Unknown |  |
| theme_logos | Unknown |  |
| theme_lower_third_background | Unknown |  |
| theme_lower_third_text_color | Unknown |  |
| theme_mobile_event_background | Unknown |  |
| theme_mobile_splash_page_hero | Unknown |  |
| theme_mobile_stage_background | Unknown |  |
| theme_name_card_background | Unknown |  |
| theme_name_card_radius | Unknown |  |
| theme_name_card_text_color | Unknown |  |
| theme_name_card_title_display | Unknown |  |
| theme_p_2_p_panel_shade_alpha | Unknown |  |
| theme_page_item_alpha | Unknown |  |
| theme_primary_background_shade | Unknown |  |
| theme_primary_color | Unknown |  |
| theme_primary_text_color | Unknown |  |
| theme_screen_saver_background | Unknown |  |
| theme_screen_saver_text_color | Unknown |  |
| theme_secondary_color | Unknown |  |
| theme_secondary_text_color | Unknown |  |
| theme_show_borders | Unknown |  |
| theme_sidebar_alpha | Unknown |  |
| theme_sidebar_blur | Unknown |  |
| theme_splash_background_color | Unknown |  |
| theme_splash_background_shade | Unknown |  |
| theme_splash_font_link | Unknown |  |
| theme_splash_font_name | Unknown |  |
| theme_splash_font_src | Unknown |  |
| theme_splash_font_type | Unknown |  |
| theme_splash_gradient_height | Unknown |  |
| theme_splash_page_hero | Unknown |  |
| theme_splash_shade_alpha | Unknown |  |
| theme_splash_text_color | Unknown |  |
| theme_splash_text_onimage_color | Unknown |  |
| theme_stage_background | Unknown |  |
| theme_stage_text_color | Unknown |  |
| theme_type | Unknown |  |
| theme_virtual_backgrounds | Unknown |  |
| timezone | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |
| updated_by | Unknown |  |
| updated_by_user_email | Unknown |  |
| updated_by_user_first_name | Unknown |  |
| updated_by_user_id | Unknown |  |
| updated_by_user_last_name | Unknown |  |
| updated_by_user_organization | Unknown |  |
| updated_by_user_profile_picture_url | Unknown |  |
| updated_by_user_role | Unknown |  |
| vivenu_event_url | Unknown |  |
| workspace_color | Unknown |  |
| workspace_icon | Unknown |  |
| workspace_id | Unknown |  |
| workspace_name | Unknown |  |

### webinar_speaker_permission_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK |
| broadcast_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| webinar_speaker_id | Unknown | PK, FK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| deleted_by_cascade | Unknown |  |
| deleted_date | Unknown |  |
| description | Unknown |  |
| is_custom | Unknown |  |
| name | Unknown |  |
| organization | Unknown |  |
| permissions | Unknown |  |
| realm | Unknown |  |
| role_group | Unknown |  |
| seat_type | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| user_count | Unknown |  |

### webinar_speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| broadcast_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| organization_user_id | Unknown | FK |
| user_id | Unknown | FK |
| allow_moderate_chat | Unknown |  |
| allow_moderate_qna | Unknown |  |
| allow_polls_control | Unknown |  |
| allow_screen_share | Unknown |  |
| allow_share_media | Unknown |  |
| allow_share_slides | Unknown |  |
| created_at | Unknown |  |
| event_app_role | Unknown |  |
| hidden | Unknown |  |
| rank | Unknown |  |
| role_id | Unknown |  |
| stage_rank | Unknown |  |
| updated_at | Unknown |  |

### webinar

| Column | Type | Keys |
| --- | --- | --- |
| broadcast_id | Unknown | PK, FK |
| event_id | Unknown | PK, FK |
| broadcast_type | Unknown |  |
| custom_stream_key | Unknown |  |
| custom_stream_url | Unknown |  |
| default_language | Unknown |  |
| disable_enter_event_button | Unknown |  |
| enable_live_captions | Unknown |  |
| enable_live_captions_translations | Unknown |  |
| end_time | Unknown |  |
| facebook_live_url | Unknown |  |
| facebook_stream_key | Unknown |  |
| have_text_qna | Unknown |  |
| have_video_qna | Unknown |  |
| hide_watcher_count | Unknown |  |
| is_available_on_demand | Unknown |  |
| is_test | Unknown |  |
| is_text_qna_moderated | Unknown |  |
| on_demand_mode | Unknown |  |
| people_tab_title | Unknown |  |
| public_chat_disabled | Unknown |  |
| record_broadcasts | Unknown |  |
| registration_page_no_agenda | Unknown |  |
| show_answerers_identity | Unknown |  |
| show_attendee_profiles | Unknown |  |
| show_attendees | Unknown |  |
| show_onboarding | Unknown |  |
| show_people_tab_speakers | Unknown |  |
| show_watcher_count_speakers | Unknown |  |
| speaker_tab_title | Unknown |  |
| speaker_tab_visible | Unknown |  |
| start_time | Unknown |  |
| textqna_answerers_alias | Unknown |  |
| thread_chat_disabled | Unknown |  |
| timezone | Unknown |  |
| title | Unknown |  |
| youtube_live_url | Unknown |  |
| youtube_stream_key | Unknown |  |

## Relationships

- ticket_type(event_id) → event(id)
- broadcast_speaker(speaker_id) → event_speaker(id)
- broadcast_speaker(broadcast_id) → broadcast(id)
- broadcast_speaker(event_id) → broadcast(event_id)
- broadcast_video_asset(broadcast_id) → broadcast(id)
- broadcast_video_asset(event_id) → broadcast(event_id)
- broadcast(organization) → organization(id)
- tag_library(organization) → organization(id)
- event_member(event_id) → event(id)
- event_member(track_id) → track(id)
- resource(event_id) → event(id)
- event_speaker(event_id) → event(id)
- booth_discussion_group(event_id) → event(id)
- booth_discussion_group(booth_id) → booth(id)
- booth_resource(event_id) → event(id)
- booth_resource(booth_id) → booth(id)
- booth(event_id) → event(id)
- agenda_item(event_id) → event(id)
- event_public_agenda_session_speaker(id) → event_speaker(id)
- event_public_agenda_session_speaker(session_id) → event_public_agenda(session_id)
- event_public_agenda_session_speaker(event_id) → event_public_agenda(event_id)
- event_public_agenda(event_id) → event(id)
- track_allowed_ticket_type(ticket_type_id) → ticket_type(id)
- track_allowed_ticket_type(track_id) → track(id)
- track(event_id) → event(id)
- event_supported_language(event_id) → event(id)
- event_form_field(event_id) → event(id)
- event(organization) → organization(id)
- webinar_speaker_permission_role(webinar_speaker_id) → webinar_speaker(id)
- webinar_speaker_permission_role(broadcast_id) → webinar_speaker(broadcast_id)
- webinar_speaker_permission_role(event_id) → webinar_speaker(event_id)
- webinar_speaker(user_id) → event_member(user_id)
- webinar_speaker(organization_user_id) → event_member(organization_user_id)
- webinar_speaker(broadcast_id) → webinar(broadcast_id)
- webinar_speaker(event_id) → webinar(event_id)
- webinar(broadcast_id) → broadcast(id)
- webinar(event_id) → event(id)