ON24

Explore the interactive ERD

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	PKFK
`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	PKFK
`poll_id`	Unknown	PKFK
`answer`	Unknown
`answer_code`	Unknown

attendee_poll

Column	Type	Keys
`attendee_id`	Unknown	PKFK
`poll_id`	Unknown	PKFK
`question`	Unknown
`question_id`	Unknown
`submitted_timestamp`	Unknown

attendee_resource

Column	Type	Keys
`attendee_id`	Unknown	PKFK
`resource_id`	Unknown	PKFK
`viewed`	Unknown
`viewed_timestamp`	Unknown

attendee_survey_answer

Column	Type	Keys
`index`	Unknown	PK
`attendee_id`	Unknown	PKFK
`question_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`answer`	Unknown
`answer_code`	Unknown

attendee_survey

Column	Type	Keys
`question_id`	Unknown	PK
`attendee_id`	Unknown	PKFK
`survey_id`	Unknown	PKFK
`question`	Unknown
`question_code`	Unknown
`submitted_timestamp`	Unknown

attendee_twitter_widget

Column	Type	Keys
`index`	Unknown	PK
`attendee_id`	Unknown	PKFK
`date`	Unknown
`tweet_description`	Unknown

attendee_call_to_action

Column	Type	Keys
`attendee_id`	Unknown	PKFK
`cta_id`	Unknown	PKFK
`action`	Unknown
`clicks`	Unknown
`cta_name`	Unknown
`date`	Unknown

attendee_test_widget

Column	Type	Keys
`index`	Unknown	PK
`attendee_id`	Unknown	PKFK
`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	PKFK
`certification_timestamp`	Unknown
`credit`	Unknown
`name`	Unknown
`result`	Unknown
`url`	Unknown

attendee_conversion

Column	Type	Keys
`id`	Unknown	PK
`attendee_id`	Unknown	PKFK
`action`	Unknown
`name`	Unknown
`submitted_timestamp`	Unknown
`type`	Unknown

attendee_location_visit

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

lead_segment

Column	Type	Keys
`index`	Unknown	PK
`lead_email`	Unknown	PKFK
`segment`	Unknown

lead

Column	Type	Keys
`email`	Unknown	PKFK
`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	PKFK
`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	PKFK
`code`	Unknown
`count`	Unknown

event_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`tags`	Unknown

event_funnel_stage

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`stage`	Unknown

event_speaker

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`company`	Unknown
`description`	Unknown
`name`	Unknown
`title`	Unknown

event_encoder

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`encoder`	Unknown
`stream_id`	Unknown
`url`	Unknown

event_survey_url

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`urls`	Unknown

event_category

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`category`	Unknown

event_track

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`track`	Unknown

event_liveday

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`id`	Unknown
`live_end_time`	Unknown
`live_start_time`	Unknown
`title`	Unknown

event_content

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`status`	Unknown
`title`	Unknown
`type`	Unknown
`url`	Unknown

event_sponsor_staff

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`event_sponsor_id`	Unknown	PKFK
`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	PKFK
`name`	Unknown

event_account_tag

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`survey_id`	Unknown	PKFK
`answer`	Unknown
`answer_code`	Unknown
`percentage`	Unknown

survey_question

Column	Type	Keys
`question_id`	Unknown	PK
`survey_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`access_mode`	Unknown
`chat_id`	Unknown
`content`	Unknown
`create_timestamp`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown