Goldcast

Explore the interactive ERD

Table & Field Reference

ticket_type

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

broadcast_video_asset

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

event_public_agenda

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

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

event_form_field

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