BigMarker

Explore the interactive ERD

Table & Field Reference

subchannel

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	PKFK
`channel_url`	Unknown
`name`	Unknown
`overview`	Unknown

conference_registration

Column	Type	Keys
`id`	Unknown	PK
`conference_id`	Unknown	PKFK
`active_consent`	Unknown
`attended`	Unknown
`banned`	Unknown
`bmid`	Unknown
`browser`	Unknown
`chats`	Unknown
`comment`	Unknown
`country`	Unknown
`coupon`	Unknown
`downloaded`	Unknown
`email`	Unknown
`engaged`	Unknown
`enter_time`	Unknown
`exit_time`	Unknown
`first_name`	Unknown
`handout_name`	Json
`last_name`	Unknown
`live_duration`	Unknown
`os`	Unknown
`polls`	Unknown
`polls_info`	Json
`qa`	Unknown
`rating`	Unknown
`recording_duration`	Unknown
`referral_domain`	Unknown
`registration_date`	Unknown
`time_zone`	Unknown
`tracking_code`	Unknown
`traffic_source`	Unknown
`view_start_time`	Unknown
`watched`	Unknown
`watched_on_demand`	Unknown
`custom_fields_`

conference_agenda_topic

Column	Type	Keys
`index`	Unknown	PK
`conference_id`	Unknown	PKFK
`topic`	Unknown

conference_presenter

Column	Type	Keys
`id`	Unknown	PK
`conference_id`	Unknown	PKFK
`bio`	Unknown
`can_manage`	Unknown
`display_name`	Unknown
`display_on_landing_page`	Unknown
`email`	Unknown
`facebook`	Unknown
`first_name`	Unknown
`is_moderator`	Unknown
`last_name`	Unknown
`linkedin`	Unknown
`member_id`	Unknown
`presenter_dial_in_id`	Unknown
`presenter_dial_in_number`	Unknown
`presenter_dial_in_passcode`	Unknown
`presenter_url`	Unknown
`title`	Unknown
`twitter`	Unknown
`website`	Unknown

conference

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	FK
`associated_series`	Json
`audience_open_time`	Unknown
`auto_invite_all_channel_members`	Unknown
`auto_publish_time`	Unknown
`auto_unpublish_time`	Unknown
`background_image_url`	Unknown
`banner_filter_percentage`	Unknown
`can_view_poll_results`	Unknown
`conference_address`	Unknown
`copy_webinar_id`	Unknown
`custom_event_id`	Unknown
`dial_in_information_id`	Unknown
`dial_in_information_number`	Unknown
`dial_in_information_passcode`	Unknown
`dial_in_information_presenter_id`	Unknown
`dial_in_information_presenter_number`	Unknown
`dial_in_information_presenter_passcode`	Unknown
`disclaimer`	Unknown
`duration`	Unknown
`enable_ie_safari`	Unknown
`enable_knock_to_enter`	Unknown
`enable_registration_email`	Unknown
`enable_review_emails`	Unknown
`enable_twitter`	Unknown
`end_time`	Unknown
`event_type`	Unknown
`exit_url`	Unknown
`fb_open_graph_image_url`	Unknown
`first_admin_enter_time`	Unknown
`is_recording_published`	Unknown
`languages`	Unknown
`last_publish_time`	Unknown
`last_unpublish_time`	Unknown
`manual_end_time`	Unknown
`master_webinar_id`	Unknown
`max_attendance`	Unknown
`meeting_mode`	Unknown
`moderator_open_time`	Unknown
`polls`	Json
`preload_files`	Json
`presenter_exit_url`	Unknown
`privacy`	Unknown
`purpose`	Unknown
`recorded`	Unknown
`recording_iframe`	Unknown
`recording_url`	Unknown
`registration_required_to_view_recording`	Unknown
`send_cancellation_email`	Unknown
`send_reminder_emails_to_presenters`	Unknown
`show_handout_on_page`	Unknown
`show_reviews`	Unknown
`start_time`	Unknown
`tags`	Json
`time_zone`	Unknown
`title`	Unknown
`type`	Unknown
`webcast_mode`	Unknown
`webhook_url`	Unknown
`webinar_stats_invited`	Unknown
`webinar_stats_page_views`	Unknown
`webinar_stats_registrants`	Unknown
`webinar_stats_revenue`	Unknown
`webinar_stats_total_attendees`	Unknown
`who_can_watch_recording`	Unknown

subscriber

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	PKFK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown

conference_no_show

Column	Type	Keys
`conference_id`	Unknown	PKFK
`conference_registration_id`	Unknown	PKFK

channel_host

Column	Type	Keys
`index`	Unknown	PK
`channel_id`	Unknown	PKFK
`host`	Unknown

channel

Column	Type	Keys
`id`	Unknown	PK
`custom_billing_tier`	Unknown
`description`	Unknown
`name`	Unknown
`overview`	Unknown
`url`	Unknown

event_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`conference_id`	Unknown	FK
`total_live_minutes_watched`	Unknown

survey_response

Column	Type	Keys
`index`	Unknown	PK
`conference_id`	Unknown	PKFK
`survey_question_title`	Unknown	PKFK
`review_created_at`	Unknown
`review_email`	Unknown
`review_name`	Unknown
`review_response`	Unknown

survey

Column	Type	Keys
`question_title`	Unknown	PK
`conference_id`	Unknown	PKFK
`answer_type`	Unknown
`choice_type`	Unknown
`is_review_question`	Unknown

conference_attendance

Column	Type	Keys
`id`	Unknown	PK
`conference_id`	Unknown	PKFK
`active_consent`	Unknown
`attended`	Unknown
`bmid`	Unknown
`browser`	Unknown
`chats`	Unknown
`comment`	Unknown
`country`	Unknown
`downloaded`	Unknown
`duration`	Unknown
`email`	Unknown
`engaged`	Unknown
`enter_time`	Unknown
`exit_time`	Unknown
`first_name`	Unknown
`handout_name`	Json
`last_name`	Unknown
`live_duration`	Unknown
`offers_info`	Json
`on_demand_duration`	Unknown
`os`	Unknown
`polls`	Unknown
`polls_info`	Json
`qa`	Unknown
`rating`	Unknown
`recording_duration`	Unknown
`referral_domain`	Unknown
`registration_date`	Unknown
`time_zone`	Unknown
`tracking_code`	Unknown
`traffic_source`	Unknown
`view_start_time`	Unknown
`watched`	Unknown
`custom_fields_`

conference_registrant_with_custom_field

Column	Type	Keys
`id`	Unknown	PK
`conference_id`	Unknown	PKFK
`bmid`	Unknown
`country`	Unknown
`coupon_used`	Unknown
`custom_fields`	Json
`custom_user_id`	Unknown
`earned_certificate`	Unknown
`email`	Unknown
`enter_url`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`qualified_for_certificate`	Unknown
`referral_domain`	Unknown
`registered_at`	Unknown
`source`	Unknown
`start_time`	Unknown
`time_zone`	Unknown
`tracking_code`	Unknown

conference_on_demand

Column	Type	Keys
`conference_attendance_id`	Unknown	PKFK
`conference_id`	Unknown	PKFK