# Mux schema ERD

Table and field reference for the Fivetran Mux connector.

## Table & Field Reference

### incident_notification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| attempted_at | Unknown |  |
| queued_at | Unknown |  |

### incident_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| incident_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affected_views | Unknown |  |
| affected_views_per_hour | Unknown |  |
| affected_views_per_hour_on_open | Unknown |  |
| description | Unknown |  |
| error_description | Unknown |  |
| impact | Unknown |  |
| incident_key | Unknown |  |
| measured_value | Unknown |  |
| measured_value_on_close | Unknown |  |
| measurement | Unknown |  |
| notification_rules | Json |  |
| resolved_at | Unknown |  |
| sample_size | Unknown |  |
| sample_size_unit | Unknown |  |
| severity | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| threshold | Unknown |  |

### space_broadcast

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | PK, FK |
| live_stream_id | Unknown | FK |
| background | Unknown |  |
| layout | Unknown |  |
| passthrough | Unknown |  |
| resolution | Unknown |  |
| status | Unknown |  |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active_session_id | Unknown |  |
| created_at | Unknown |  |
| passthrough | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### error

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| count | Unknown |  |
| description | Unknown |  |
| last_seen | Unknown |  |
| message | Unknown |  |
| notes | Unknown |  |
| percentage | Unknown |  |

### delivery_usage

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| live_stream_id | Unknown | FK |
| asset_id | Unknown |  |
| asset_state | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| delivered_seconds | Unknown |  |
| delivered_seconds_by_resolution_tier_1080_p | Unknown |  |
| delivered_seconds_by_resolution_tier_720_p | Unknown |  |
| delivered_seconds_by_resolution_tier_audio_only | Unknown |  |
| passthrough | Unknown |  |

### related_incident

| Column | Type | Keys |
| --- | --- | --- |
| related_incident_id | Unknown | PK |
| incident_id | Unknown | PK, FK |

### asset_track

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | PK, FK |
| closed_captions | Unknown |  |
| language_code | Unknown |  |
| max_channel_layout | Unknown |  |
| max_channels | Unknown |  |
| max_frame_rate | Unknown |  |
| max_height | Unknown |  |
| max_width | Unknown |  |
| name | Unknown |  |
| passthrough | Unknown |  |
| status | Unknown |  |
| text_source | Unknown |  |
| text_type | Unknown |  |
| type | Unknown |  |

### asset_error_message

| Column | Type | Keys |
| --- | --- | --- |
| message | Unknown | PK |
| asset_id | Unknown | PK, FK |

### asset_static_renditions_file

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown | FK |
| bitrate | Unknown |  |
| ext | Unknown |  |
| filesize | Unknown |  |
| height | Unknown |  |
| name | Unknown |  |
| width | Unknown |  |

### asset_recording_time

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown | FK |
| duration | Unknown |  |
| started_at | Unknown |  |
| type | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| live_stream_id | Unknown | FK |
| aspect_ratio | Unknown |  |
| created_at | Unknown |  |
| duration | Unknown |  |
| error_type | Unknown |  |
| is_live | Unknown |  |
| master_access | Unknown |  |
| master_status | Unknown |  |
| master_url | Unknown |  |
| max_stored_frame_rate | Unknown |  |
| max_stored_resolution | Unknown |  |
| mp_4_support | Unknown |  |
| non_standard_input_reasons_audio_codec | Unknown |  |
| non_standard_input_reasons_audio_edit_list | Unknown |  |
| non_standard_input_reasons_pixel_aspect_ratio | Unknown |  |
| non_standard_input_reasons_unexpected_media_file_parameters | Unknown |  |
| non_standard_input_reasons_unsupported_pixel_format | Unknown |  |
| non_standard_input_reasons_video_bitrate | Unknown |  |
| non_standard_input_reasons_video_codec | Unknown |  |
| non_standard_input_reasons_video_edit_list | Unknown |  |
| non_standard_input_reasons_video_frame_rate | Unknown |  |
| non_standard_input_reasons_video_gop_size | Unknown |  |
| non_standard_input_reasons_video_resolution | Unknown |  |
| normalize_audio | Unknown |  |
| passthrough | Unknown |  |
| source_asset_id | Unknown |  |
| static_renditions_status | Unknown |  |
| status | Unknown |  |
| test | Unknown |  |
| upload_id | Unknown |  |

### playback

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| type | Unknown | PK |
| parent_id | Unknown | PK, FK |
| policy | Unknown |  |

### livestream_playback_policy

| Column | Type | Keys |
| --- | --- | --- |
| playback_policies | Unknown | PK |
| live_stream_id | Unknown | PK, FK |

### simulcast_target

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| live_stream_id | Unknown | PK, FK |
| passthrough | Unknown |  |
| status | Unknown |  |
| stream_key | Unknown |  |
| url | Unknown |  |

### livestream_embedded_subtitle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| live_stream_id | Unknown | PK, FK |
| language_channel | Unknown |  |
| language_code | Unknown |  |
| name | Unknown |  |
| passthrough | Unknown |  |

### livestream_generated_subtitle_transcription_vocabulary

| Column | Type | Keys |
| --- | --- | --- |
| transcription_vocabulary_id | Unknown | PK |
| livestream_generated_subtitle_index | Unknown | PK, FK |
| livestream_generated_subtitle_live_stream_id | Unknown | PK, FK |

### livestream_generated_subtitle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| live_stream_id | Unknown | PK, FK |
| language_code | Unknown |  |
| name | Unknown |  |
| passthrough | Unknown |  |

### live_stream

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active_asset_id | Unknown | FK |
| audio_only | Unknown |  |
| created_at | Unknown |  |
| latency_mode | Unknown |  |
| max_continuous_duration | Unknown |  |
| passthrough | Unknown |  |
| reconnect_slate_url | Unknown |  |
| reconnect_window | Unknown |  |
| status | Unknown |  |
| stream_key | Unknown |  |
| test | Unknown |  |
| use_slate_for_standard_latency | Unknown |  |

### asset_input_info_track

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| channels | Unknown |  |
| duration | Unknown |  |
| encoding | Unknown |  |
| frame_rate | Unknown |  |
| height | Unknown |  |
| sample_rate | Unknown |  |
| sample_size | Unknown |  |
| type | Unknown |  |
| width | Unknown |  |

### asset_input_info

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| asset_id | Unknown | FK |
| file_container_format | Unknown |  |
| settings_url | Unknown |  |

### video_view_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| video_view_id | Unknown | FK |
| event_time | Unknown |  |
| name | Unknown |  |
| playback_time | Unknown |  |
| viewer_time | Unknown |  |

### video_view

| Column | Type | Keys |
| --- | --- | --- |
| view_id | Unknown | PK |
| live_stream_id | Unknown | FK |
| video_id | Unknown | FK |
| asn | Unknown |  |
| city | Unknown |  |
| country_name | Unknown |  |
| exit_before_video_start | Unknown |  |
| player_error_code | Unknown |  |
| player_error_message | Unknown |  |
| player_mux_plugin_name | Unknown |  |
| player_source_host_name | Unknown |  |
| player_source_url | Unknown |  |
| view_end | Unknown |  |
| view_max_downscale_percentage | Unknown |  |
| view_max_playhead_position | Unknown |  |
| view_max_upscale_percentage | Unknown |  |
| view_playing_time | Unknown |  |
| view_start | Unknown |  |
| view_total_content_playback_time | Unknown |  |
| viewer_device_model | Unknown |  |
| viewer_os_version | Unknown |  |
| weighted_average_bitrate | Unknown |  |
| custom_** |  |  |

### referrer_allowed_domain

| Column | Type | Keys |
| --- | --- | --- |
| allowed_domain | Unknown | PK |
| playback_restriction_id | Unknown | PK, FK |

### playback_restriction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| referrer_allow_no_referrer | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- incident_notification(incident_id) → incident(id)
- incident_breakdown(incident_id) → incident(id)
- space_broadcast(live_stream_id) → live_stream(id)
- space_broadcast(space_id) → space(id)
- delivery_usage(live_stream_id) → live_stream(id)
- delivery_usage(id) → asset(id)
- related_incident(incident_id) → incident(id)
- asset_track(asset_id) → asset(id)
- asset_error_message(asset_id) → asset(id)
- asset_static_renditions_file(asset_id) → asset(id)
- asset_recording_time(asset_id) → asset(id)
- asset(live_stream_id) → live_stream(id)
- playback(parent_id) → live_stream(id)
- livestream_playback_policy(live_stream_id) → live_stream(id)
- simulcast_target(live_stream_id) → live_stream(id)
- livestream_embedded_subtitle(live_stream_id) → live_stream(id)
- livestream_generated_subtitle_transcription_vocabulary(livestream_generated_subtitle_index) → livestream_generated_subtitle(index)
- livestream_generated_subtitle_transcription_vocabulary(livestream_generated_subtitle_live_stream_id) → livestream_generated_subtitle(live_stream_id)
- livestream_generated_subtitle(live_stream_id) → live_stream(id)
- live_stream(active_asset_id) → asset(id)
- asset_input_info_track(_fivetran_id) → asset_input_info(_fivetran_id)
- asset_input_info(asset_id) → asset(id)
- video_view_event(video_view_id) → video_view(view_id)
- video_view(live_stream_id) → live_stream(id)
- video_view(video_id) → asset(id)
- referrer_allowed_domain(playback_restriction_id) → playback_restriction(id)