# ON24 schema ERD

Table and field reference for the Fivetran ON24 connector.

## Table & Field Reference

### event_media

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| index | Unknown | PK |
| audio | Json |  |
| poll | Json |  |
| slide | Json |  |
| urls | Json |  |
| video | Json |  |
| video_clip | Json |  |

### presenter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| access_mode | Unknown |  |
| client_id | Unknown |  |
| end_time | Unknown |  |
| is_practice_session | Unknown |  |
| session_id | Unknown |  |
| start_time | Unknown |  |

### attendee_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| presenter_id | Unknown | FK |
| answer_content | Unknown |  |
| answer_create_timestamp | Unknown |  |
| content | Unknown |  |
| create_timestamp | Unknown |  |
| privacy | Unknown |  |

### attendee_poll_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| poll_id | Unknown | PK, FK |
| answer | Unknown |  |
| answer_code | Unknown |  |

### attendee_poll

| Column | Type | Keys |
| --- | --- | --- |
| attendee_id | Unknown | PK, FK |
| poll_id | Unknown | PK, FK |
| question | Unknown |  |
| question_id | Unknown |  |
| submitted_timestamp | Unknown |  |

### attendee_resource

| Column | Type | Keys |
| --- | --- | --- |
| attendee_id | Unknown | PK, FK |
| resource_id | Unknown | PK, FK |
| viewed | Unknown |  |
| viewed_timestamp | Unknown |  |

### attendee_survey_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| question_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| answer | Unknown |  |
| answer_code | Unknown |  |

### attendee_survey

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| question | Unknown |  |
| question_code | Unknown |  |
| submitted_timestamp | Unknown |  |

### attendee_twitter_widget

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| date | Unknown |  |
| tweet_description | Unknown |  |

### attendee_call_to_action

| Column | Type | Keys |
| --- | --- | --- |
| attendee_id | Unknown | PK, FK |
| cta_id | Unknown | PK, FK |
| action | Unknown |  |
| clicks | Unknown |  |
| cta_name | Unknown |  |
| date | Unknown |  |

### attendee_test_widget

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| correct_answers_needed | Unknown |  |
| correct_answers_provided | Unknown |  |
| retries | Unknown |  |
| test_widget_result | Unknown |  |

### attendee_certification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| certification_timestamp | Unknown |  |
| credit | Unknown |  |
| name | Unknown |  |
| result | Unknown |  |
| url | Unknown |  |

### attendee_conversion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| action | Unknown |  |
| name | Unknown |  |
| submitted_timestamp | Unknown |  |
| type | Unknown |  |

### attendee_location_visit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| code | Unknown |  |
| cumulative_visit_duration | Unknown |  |
| name | Unknown |  |
| sponsor_id | Unknown |  |
| visit | Unknown |  |
| visit_duration | Unknown |  |

### attendee_breakout

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| attendee_id | Unknown | PK, FK |
| cumulative_live_minute | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |

### attendee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| answered_poll | Unknown |  |
| answered_survey | Unknown |  |
| answered_survey_question | Unknown |  |
| archive_minute | Unknown |  |
| archive_viewed | Unknown |  |
| asked_question | Unknown |  |
| attendance_partner_ref | Unknown |  |
| campaign_code | Unknown |  |
| certification_credit | Unknown |  |
| certification_timestamp | Unknown |  |
| certification_widget_result | Unknown |  |
| client_id | Unknown |  |
| cumulative_archive_minute | Unknown |  |
| cumulative_live_minute | Unknown |  |
| email | Unknown |  |
| engagement_score | Unknown |  |
| ext_event_user_cd | Unknown |  |
| first_archive_activity | Unknown |  |
| first_live_activity | Unknown |  |
| is_blocked | Unknown |  |
| last_archive_activity | Unknown |  |
| last_live_activity | Unknown |  |
| launch_mode | Unknown |  |
| live_minute | Unknown |  |
| live_viewed | Unknown |  |
| partner_ref | Unknown |  |
| resource_downloaded | Unknown |  |
| source_campaign_code | Unknown |  |
| source_event_id | Unknown |  |
| test_widget_result | Unknown |  |
| user_profile_url | Unknown |  |
| user_status | Unknown |  |
| custom_** |  |  |

### registrant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| attendee_type | Unknown |  |
| browser | Unknown |  |
| campaign_code | Unknown |  |
| city | Unknown |  |
| client_id | Unknown |  |
| company | Unknown |  |
| company_industry | Unknown |  |
| company_size | Unknown |  |
| country | Unknown |  |
| create_timestamp | Unknown |  |
| email | Unknown |  |
| email_format | Unknown |  |
| engagement_prediction | Unknown |  |
| event_email | Unknown |  |
| ext_event_user_cd | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| home_phone | Unknown |  |
| ip_address | Unknown |  |
| job_function | Unknown |  |
| job_title | Unknown |  |
| last_activity | Unknown |  |
| last_name | Unknown |  |
| marketing_email | Unknown |  |
| notes | Unknown |  |
| os | Unknown |  |
| other | Unknown |  |
| partner_ref | Unknown |  |
| source_campaign_code | Unknown |  |
| source_event_id | Unknown |  |
| state | Unknown |  |
| user_profile_url | Unknown |  |
| user_status | Unknown |  |
| username | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |
| work_phone | Unknown |  |
| zip | Unknown |  |
| custom_** |  |  |

### lead_business_interest

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_email | Unknown | PK, FK |
| business | Unknown |  |

### lead_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_email | Unknown | PK, FK |
| segment | Unknown |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK, FK |
| engagement_level | Unknown |  |
| user_profile_url | Unknown |  |
| custom_** |  |  |

### call_to_action

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| action | Unknown |  |
| action_type | Unknown |  |
| name | Unknown |  |
| total_click | Unknown |  |
| unique_click | Unknown |  |

### event_analytics

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| attendee_who_downloaded_resource | Unknown |  |
| average_archive_minute | Unknown |  |
| average_cumulative_archive_minute | Unknown |  |
| average_cumulative_live_minute | Unknown |  |
| average_live_minute | Unknown |  |
| event_engagement_score | Unknown |  |
| live_attendee | Unknown |  |
| noshow_count | Unknown |  |
| number_of_cta_click | Unknown |  |
| number_of_demo_conversion | Unknown |  |
| number_of_drift | Unknown |  |
| number_of_freetrial_request | Unknown |  |
| number_of_groupchat_message_submitted | Unknown |  |
| number_of_meeting_conversion | Unknown |  |
| number_of_poll_pushed | Unknown |  |
| number_of_poll_response | Unknown |  |
| number_of_question_answered | Unknown |  |
| number_of_question_asked | Unknown |  |
| number_of_resource_available | Unknown |  |
| number_of_survey_presented | Unknown |  |
| number_of_survey_response | Unknown |  |
| number_of_test_passed | Unknown |  |
| number_of_test_submitted | Unknown |  |
| ondemand_attendee | Unknown |  |
| registration_page_hit | Unknown |  |
| share_this_widget_total_view | Unknown |  |
| share_this_widget_unique_view | Unknown |  |
| total_attendee | Unknown |  |
| total_registrant | Unknown |  |
| twitter_widget_total_view | Unknown |  |
| twitter_widget_unique_view | Unknown |  |
| unique_attendee_resource_download | Unknown |  |

### event_partner_refstat

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

### event_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| tags | Unknown |  |

### event_funnel_stage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| stage | Unknown |  |

### event_speaker

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| company | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| title | Unknown |  |

### event_encoder

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| encoder | Unknown |  |
| stream_id | Unknown |  |
| url | Unknown |  |

### event_survey_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| urls | Unknown |  |

### event_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| category | Unknown |  |

### event_track

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| track | Unknown |  |

### event_liveday

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| id | Unknown |  |
| live_end_time | Unknown |  |
| live_start_time | Unknown |  |
| title | Unknown |  |

### event_content

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### event_sponsor_staff

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| event_sponsor_id | Unknown | PK, FK |
| company | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| role | Unknown |  |
| title | Unknown |  |

### event_sponsor

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

### event_account_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| group_id | Unknown |  |
| group_name | Unknown |  |
| tag_id | Unknown |  |
| tag_name | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application | Unknown |  |
| archive_end | Unknown |  |
| archive_start | Unknown |  |
| audience_key | Unknown |  |
| audience_url | Unknown |  |
| category | Unknown |  |
| client_id | Unknown |  |
| content_type | Unknown |  |
| create_timestamp | Unknown |  |
| description | Unknown |  |
| display_timezone_cd | Unknown |  |
| event_duration | Unknown |  |
| event_location | Unknown |  |
| event_profile | Unknown |  |
| event_type | Unknown |  |
| ext_audience_url | Unknown |  |
| good_after | Unknown |  |
| good_till | Unknown |  |
| industry | Unknown |  |
| is_active | Unknown |  |
| is_elite_expired | Unknown |  |
| is_hybrid_event | Unknown |  |
| keyword | Unknown |  |
| last_modified | Unknown |  |
| last_updated | Unknown |  |
| live_end | Unknown |  |
| live_start | Unknown |  |
| locale_country_cd | Unknown |  |
| locale_language_cd | Unknown |  |
| name | Unknown |  |
| pm_url | Unknown |  |
| presenter_media_audio_file | Unknown |  |
| presenter_media_video_file | Unknown |  |
| preview_url | Unknown |  |
| promotional_summary | Unknown |  |
| qanda_email | Unknown |  |
| reg_notification_required | Unknown |  |
| reg_required | Unknown |  |
| report_url | Unknown |  |
| scheduled_event_duration | Unknown |  |
| service_type | Unknown |  |
| single_file_archive | Unknown |  |
| sponsor | Unknown |  |
| stream_type | Unknown |  |
| upload_url | Unknown |  |
| custom_** |  |  |

### attendee_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| browser | Unknown |  |
| duration | Unknown |  |
| email | Unknown |  |
| end_time | Unknown |  |
| ext_event_user_cd | Unknown |  |
| first_name | Unknown |  |
| ip_address | Unknown |  |
| last_name | Unknown |  |
| launch_mode | Unknown |  |
| media_stream | Unknown |  |
| os | Unknown |  |
| start_time | Unknown |  |
| stream_source | Unknown |  |
| usage | Unknown |  |

### poll_summary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| poll_id | Unknown | PK, FK |
| answer | Unknown |  |
| answer_code | Unknown |  |
| percentage | Unknown |  |

### poll

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| question | Unknown |  |
| question_id | Unknown |  |
| total_vote | Unknown |  |
| type | Unknown |  |

### survey_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| question_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| answer | Unknown |  |
| answer_code | Unknown |  |
| percentage | Unknown |  |

### survey_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| question | Unknown |  |
| question_type | Unknown |  |
| response | Unknown |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| code | Unknown |  |

### group_chat_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| group_chat_id | Unknown | PK, FK |
| event_user_id | Unknown | FK |
| chat_message | Unknown |  |
| create_timestamp | Unknown |  |

### group_chat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| name | Unknown |  |
| total_view | Unknown |  |
| unique_viewer | Unknown |  |

### content_activity

| Column | Type | Keys |
| --- | --- | --- |
| client_id | Unknown | PK |
| event_id | Unknown | PK, FK |
| average_viewing_duration | Unknown |  |
| comment | Unknown |  |
| content_type | Unknown |  |
| description | Unknown |  |
| dislike | Unknown |  |
| download | Unknown |  |
| likes | Unknown |  |
| share | Unknown |  |
| total_view | Unknown |  |
| total_viewing_duration | Unknown |  |
| unique_viewer | Unknown |  |

### resource

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| resource_id | Unknown | PK |
| resource_name | Unknown |  |
| total_download | Unknown |  |
| type | String |  |
| unique_download | Unknown |  |

### email_notification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| activated | Unknown |  |
| body | Unknown |  |
| email_from | Unknown |  |
| from_label | Unknown |  |
| good_after | Unknown |  |
| reply_to | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |
| when_to_send | Unknown |  |

### presenter_chat

| Column | Type | Keys |
| --- | --- | --- |
| presenter_id | Unknown | PK, FK |
| access_mode | Unknown |  |
| chat_id | Unknown |  |
| content | Unknown |  |
| create_timestamp | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

## Relationships

- presenter(event_id) → event(id)
- attendee_question(presenter_id) → presenter(id)
- attendee_question(attendee_id) → attendee(id)
- attendee_poll_answer(poll_id) → attendee_poll(poll_id)
- attendee_poll_answer(attendee_id) → attendee_poll(attendee_id)
- attendee_poll(poll_id) → poll(id)
- attendee_poll(attendee_id) → attendee(id)
- attendee_resource(resource_id) → resource(resource_id)
- attendee_resource(attendee_id) → attendee(id)
- attendee_survey_answer(survey_id) → attendee_survey(survey_id)
- attendee_survey_answer(question_id) → attendee_survey(question_id)
- attendee_survey_answer(attendee_id) → attendee_survey(attendee_id)
- attendee_survey(survey_id) → survey(id)
- attendee_survey(attendee_id) → attendee(id)
- attendee_twitter_widget(attendee_id) → attendee(id)
- attendee_call_to_action(cta_id) → call_to_action(id)
- attendee_call_to_action(attendee_id) → attendee(id)
- attendee_test_widget(attendee_id) → attendee(id)
- attendee_certification(attendee_id) → attendee(id)
- attendee_conversion(attendee_id) → attendee(id)
- attendee_location_visit(attendee_id) → attendee(id)
- attendee_breakout(attendee_id) → attendee(id)
- attendee(event_id) → event(id)
- registrant(event_id) → event(id)
- lead_business_interest(lead_email) → lead(email)
- lead_segment(lead_email) → lead(email)
- lead(email) → attendee(email)
- call_to_action(event_id) → event(id)
- event_analytics(event_id) → event(id)
- event_partner_refstat(event_id) → event(id)
- event_tag(event_id) → event(id)
- event_funnel_stage(event_id) → event(id)
- event_speaker(event_id) → event(id)
- event_encoder(event_id) → event(id)
- event_survey_url(event_id) → event(id)
- event_category(event_id) → event(id)
- event_track(event_id) → event(id)
- event_liveday(event_id) → event(id)
- event_content(event_id) → event(id)
- event_sponsor_staff(event_id) → event_sponsor(event_id)
- event_sponsor_staff(event_sponsor_id) → event_sponsor(id)
- event_sponsor(event_id) → event(id)
- event_account_tag(event_id) → event(id)
- attendee_session(event_id) → event(id)
- poll_summary(poll_id) → poll(id)
- poll(event_id) → event(id)
- survey_answer(question_id) → survey_question(question_id)
- survey_answer(survey_id) → survey_question(survey_id)
- survey_question(survey_id) → survey(id)
- survey(event_id) → event(id)
- group_chat_message(event_user_id) → attendee(id)
- group_chat_message(group_chat_id) → group_chat(id)
- group_chat(event_id) → event(id)
- content_activity(event_id) → event(id)
- email_notification(event_id) → event(id)
- presenter_chat(presenter_id) → presenter(id)