Brightcove

Explore the interactive ERD

Table & Field Reference

live_analytics_time_series_video_impression_data_point

Column	Type	Keys
`_fivetran_id`	String	PK
`dimensions_video`	Unknown	FK
`_timestamp`	Unknown
`dimensions_account`	Unknown
`value`	Unknown

live_analytics_time_series_video_view_data_point

Column	Type	Keys
`_fivetran_id`	String	PK
`dimensions_video`	Unknown	FK
`_timestamp`	Unknown
`dimensions_account`	Unknown
`value`	Unknown

live_analytics_time_series_second_viewed_data_point

Column	Type	Keys
`_fivetran_id`	String	PK
`dimensions_video`	Unknown	FK
`_timestamp`	Unknown
`dimensions_account`	Unknown
`value`	Unknown

live_analytics_time_series_fingerprint_count_data_point

Column	Type	Keys
`_fivetran_id`	String	PK
`dimensions_video`	Unknown	FK
`_timestamp`	Unknown
`dimensions_account`	Unknown
`value`	Unknown

live_analytics_time_series_ccu_data_point

Column	Type	Keys
`_fivetran_id`	String	PK
`dimensions_video`	Unknown	FK
`_timestamp`	Unknown
`dimensions_account`	Unknown
`value`	Unknown

video_engagement_value

Column	Type	Keys
`index`	Unknown	PK
`video_engagement_type`	Unknown	PKFK
`video_id`	Unknown	PKFK
`value`	Unknown

video_engagement

Column	Type	Keys
`type`	Unknown	PK
`video_id`	Unknown	PKFK
`video_duration`	Unknown

video_cue_point

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`force_stop`	Unknown
`metadata`	Unknown
`name`	Unknown
`time`	Unknown
`type`	Unknown

video_country

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`country`	Unknown

video_label

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`label`	Unknown

video_tag

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`tag_name`	Unknown

video_text_track

Column	Type	Keys
`id`	Unknown	PK
`video_id`	Unknown	PKFK
`default_`	Unknown
`kind`	Unknown
`label`	Unknown
`mime_type`	Unknown
`src`	Unknown
`srclang`	Unknown
`status`	Unknown

video_transcript

Column	Type	Keys
`id`	Unknown	PK
`video_id`	Unknown	PKFK
`account_id`	Unknown
`label`	Unknown
`source`	Json
`src`	Unknown
`srclang`	Unknown
`status`	Unknown

video_variant

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`description`	Unknown
`language_`	Unknown
`long_description`	Unknown
`name`	Unknown
`custom_`

video

Column	Type	Keys
`id`	Unknown	PK
`ad_keys`	Unknown
`clip_source_video_id`	Unknown
`complete`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`created_by_type`	Unknown
`delivery_type`	Unknown
`description`	Unknown
`digital_master_id`	Unknown
`drm_disabled`	Unknown
`duration`	Unknown
`economics`	Unknown
`folder_id`	Unknown
`forensic_watermarking`	Unknown
`geo_exclude_countries`	Unknown
`geo_restricted`	Unknown
`has_digital_master`	Unknown
`image_portrait_src`	Unknown
`image_poster_src`	Unknown
`image_square_src`	Unknown
`image_thumbnail_src`	Unknown
`image_ultra_wide_src`	Unknown
`image_wide_src`	Unknown
`link_text`	Unknown
`link_url`	Unknown
`long_description`	Unknown
`name`	Unknown
`offline_enabled`	Unknown
`original_filename`	Unknown
`playback_rights_id`	Unknown
`projection`	Unknown
`published_at`	Unknown
`reference_id`	Unknown
`schedule_ends_at`	Unknown
`schedule_starts_at`	Unknown
`sharing_by_external_acct`	Unknown
`sharing_by_id`	Unknown
`sharing_by_reference`	Unknown
`sharing_source_id`	Unknown
`sharing_to_external_acct`	Unknown
`state`	Unknown
`updated_at`	Instant
`updated_by_email`	Unknown
`updated_by_id`	Unknown
`updated_by_type`	Unknown
`custom_`

video_image_source

Column	Type	Keys
`index`	Unknown	PK
`video_id`	Unknown	PKFK
`height`	Unknown
`object_type`	String
`src`	Unknown
`width`	Unknown

analytics_report

Column	Type	Keys
`_fivetran_id`	String	PK
`video_id`	Unknown	FK
`ad_mode_begin`	Unknown
`ad_mode_complete`	Unknown
`bytes_delivered`	Unknown
`date`	Unknown
`engagement_score`	Unknown
`play_rate`	Unknown
`play_request`	Unknown
`temp_summary_summary_account`	Unknown
`temp_summary_summary_ad_mode_begin`	Unknown
`temp_summary_summary_ad_mode_complete`	Unknown
`temp_summary_summary_bytes_delivered`	Unknown
`temp_summary_summary_engagement_score`	Unknown
`temp_summary_summary_play_rate`	Unknown
`temp_summary_summary_play_request`	Unknown
`temp_summary_summary_video_download_cancellation`	Unknown
`temp_summary_summary_video_download_complete`	Unknown
`temp_summary_summary_video_download_error`	Unknown
`temp_summary_summary_video_download_request`	Unknown
`temp_summary_summary_video_engagement_1`	Unknown
`temp_summary_summary_video_engagement_100`	Unknown
`temp_summary_summary_video_engagement_25`	Unknown
`temp_summary_summary_video_engagement_50`	Unknown
`temp_summary_summary_video_engagement_75`	Unknown
`temp_summary_summary_video_impression`	Unknown
`temp_summary_summary_video_percent_viewed`	Unknown
`temp_summary_summary_video_seconds_viewed`	Unknown
`temp_summary_summary_video_view`	Unknown
`video_complete`	Unknown
`video_created_at`	Unknown
`video_description`	Unknown
`video_download_cancellation`	Unknown
`video_download_complete`	Unknown
`video_download_error`	Unknown
`video_download_request`	Unknown
`video_duration`	Unknown
`video_economics`	Unknown
`video_engagement_1`	Unknown
`video_engagement_100`	Unknown
`video_engagement_25`	Unknown
`video_engagement_50`	Unknown
`video_engagement_75`	Unknown
`video_impression`	Unknown
`video_long_description`	Unknown
`video_name`	Unknown
`video_percent_viewed`	Unknown
`video_reference_id`	Unknown
`video_seconds_viewed`	Unknown
`video_state`	Unknown
`video_tag`	Json
`video_updated_at`	Unknown
`video_view`	Unknown

live_analytics_event

Column	Type	Keys
`_fivetran_id`	String	PK
`video_id`	Unknown	FK
`dimensions_country`	Unknown
`totals_alive_ss_ad_start`	Unknown
`totals_live_unique_viewers`	Unknown
`totals_video_seconds_viewed`	Unknown

all_time_video_view

Column	Type	Keys
`_fivetran_id`	String	PK
`video_id`	Unknown	FK
`all_time_video_view`	Unknown