# Brightcove schema ERD

Table and field reference for the Fivetran Brightcove connector.

## 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 | PK, FK |
| video_id | Unknown | PK, FK |
| value | Unknown |  |

### video_engagement

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| video_id | Unknown | PK, FK |
| video_duration | Unknown |  |

### video_cue_point

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| force_stop | Unknown |  |
| metadata | Unknown |  |
| name | Unknown |  |
| time | Unknown |  |
| type | Unknown |  |

### video_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| country | Unknown |  |

### video_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| label | Unknown |  |

### video_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| tag_name | Unknown |  |

### video_text_track

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| video_id | Unknown | PK, FK |
| 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 | PK, FK |
| account_id | Unknown |  |
| label | Unknown |  |
| source | Json |  |
| src | Unknown |  |
| srclang | Unknown |  |
| status | Unknown |  |

### video_variant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| video_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- live_analytics_time_series_video_impression_data_point(dimensions_video) → video(id)
- live_analytics_time_series_video_view_data_point(dimensions_video) → video(id)
- live_analytics_time_series_second_viewed_data_point(dimensions_video) → video(id)
- live_analytics_time_series_fingerprint_count_data_point(dimensions_video) → video(id)
- live_analytics_time_series_ccu_data_point(dimensions_video) → video(id)
- video_engagement_value(video_engagement_type) → video_engagement(type)
- video_engagement_value(video_id) → video_engagement(video_id)
- video_engagement(video_id) → video(id)
- video_cue_point(video_id) → video(id)
- video_country(video_id) → video(id)
- video_label(video_id) → video(id)
- video_tag(video_id) → video(id)
- video_text_track(video_id) → video(id)
- video_transcript(video_id) → video(id)
- video_variant(video_id) → video(id)
- video_image_source(video_id) → video(id)
- analytics_report(video_id) → video(id)
- live_analytics_event(video_id) → video(id)
- all_time_video_view(video_id) → video(id)