# BigMarker schema ERD

Table and field reference for the Fivetran BigMarker connector.

## Table & Field Reference

### subchannel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel_id | Unknown | PK, FK |
| channel_url | Unknown |  |
| name | Unknown |  |
| overview | Unknown |  |

### conference_registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conference_id | Unknown | PK, FK |
| 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 | PK, FK |
| topic | Unknown |  |

### conference_presenter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conference_id | Unknown | PK, FK |
| 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 | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### conference_no_show

| Column | Type | Keys |
| --- | --- | --- |
| conference_id | Unknown | PK, FK |
| conference_registration_id | Unknown | PK, FK |

### channel_host

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| channel_id | Unknown | PK, FK |
| 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 | PK, FK |
| survey_question_title | Unknown | PK, FK |
| review_created_at | Unknown |  |
| review_email | Unknown |  |
| review_name | Unknown |  |
| review_response | Unknown |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| question_title | Unknown | PK |
| conference_id | Unknown | PK, FK |
| answer_type | Unknown |  |
| choice_type | Unknown |  |
| is_review_question | Unknown |  |

### conference_attendance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conference_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| conference_id | Unknown | PK, FK |

## Relationships

- subchannel(channel_id) → channel(id)
- conference_registration(conference_id) → conference(id)
- conference_agenda_topic(conference_id) → conference(id)
- conference_presenter(conference_id) → conference(id)
- conference(channel_id) → channel(id)
- subscriber(channel_id) → channel(id)
- conference_no_show(conference_registration_id) → conference_registration(id)
- conference_no_show(conference_id) → conference(id)
- channel_host(channel_id) → channel(id)
- event_summary(conference_id) → conference(id)
- survey_response(conference_id) → survey(conference_id)
- survey_response(survey_question_title) → survey(question_title)
- survey(conference_id) → conference(id)
- conference_attendance(conference_id) → conference(id)
- conference_registrant_with_custom_field(conference_id) → conference(id)
- conference_on_demand(conference_attendance_id) → conference_attendance(id)
- conference_on_demand(conference_id) → conference(id)