# The Movie Database schema ERD

Table and field reference for the Fivetran The Movie Database connector.

## Table & Field Reference

### tv_series_video

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| iso_3166_1 | Unknown |  |
| iso_639_1 | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| official | Unknown |  |
| published_at | Unknown |  |
| site | Unknown |  |
| size | Unknown |  |
| type | Unknown |  |

### tv_series_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| languages | Unknown |  |

### tv_series_created_by

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| credit_id | Unknown |  |
| gender | Unknown |  |
| name | Unknown |  |
| original_name | Unknown |  |
| profile_path | Unknown |  |

### tv_series_genre

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

### tv_series_network

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| logo_path | Unknown |  |
| name | Unknown |  |
| origin_country | Unknown |  |

### tv_series_production_company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| logo_path | Unknown |  |
| name | Unknown |  |
| origin_country | Unknown |  |

### tv_series_production_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| iso_3166_1 | Unknown |  |
| name | Unknown |  |

### tv_series_season

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| air_date | Unknown |  |
| episode_count | Unknown |  |
| name | Unknown |  |
| overview | Unknown |  |
| poster_path | Unknown |  |
| season_number | Unknown |  |
| vote_average | Unknown |  |

### tv_series_spoken_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tv_series_id | Unknown | PK, FK |
| english_name | Unknown |  |
| iso_639_1 | Unknown |  |
| name | Unknown |  |

### tv_series

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adult | Unknown |  |
| backdrop_path | Unknown |  |
| episode_run_time | Json |  |
| first_air_date | Unknown |  |
| homepage | Unknown |  |
| in_production | Unknown |  |
| last_air_date | Unknown |  |
| last_episode_to_air_date | Unknown |  |
| last_episode_to_air_episode_number | Unknown |  |
| last_episode_to_air_episode_type | Unknown |  |
| last_episode_to_air_id | Unknown |  |
| last_episode_to_air_name | Unknown |  |
| last_episode_to_air_overview | Unknown |  |
| last_episode_to_air_production_code | Unknown |  |
| last_episode_to_air_runtime | Unknown |  |
| last_episode_to_air_season_number | Unknown |  |
| last_episode_to_air_show_id | Unknown |  |
| last_episode_to_air_still_path | Unknown |  |
| last_episode_to_air_vote_average | Unknown |  |
| last_episode_to_air_vote_count | Unknown |  |
| name | Unknown |  |
| next_episode_to_air | Unknown |  |
| number_of_episodes | Unknown |  |
| number_of_seasons | Unknown |  |
| origin_country | Json |  |
| original_language | Unknown |  |
| original_name | Unknown |  |
| overview | Unknown |  |
| popularity | Unknown |  |
| poster_path | Unknown |  |
| status | Unknown |  |
| tagline | Unknown |  |
| type | Unknown |  |
| vote_average | Unknown |  |
| vote_count | Unknown |  |

### movie_video

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| movie_id | Unknown | PK, FK |
| iso_3166_1 | Unknown |  |
| iso_639_1 | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| official | Unknown |  |
| published_at | Unknown |  |
| site | Unknown |  |
| size | Unknown |  |
| type | Unknown |  |

### movie_genre

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

### movie_production_company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| movie_id | Unknown | PK, FK |
| logo_path | Unknown |  |
| name | Unknown |  |
| origin_country | Unknown |  |

### movie_production_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| movie_id | Unknown | PK, FK |
| iso_3166_1 | Unknown |  |
| name | Unknown |  |

### movie_spoken_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| movie_id | Unknown | PK, FK |
| english_name | Unknown |  |
| iso_639_1 | Unknown |  |
| name | Unknown |  |

### movie

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adult | Unknown |  |
| backdrop_path | Unknown |  |
| belongs_to_collection_backdrop_path | Unknown |  |
| belongs_to_collection_id | Unknown |  |
| belongs_to_collection_name | Unknown |  |
| belongs_to_collection_poster_path | Unknown |  |
| budget | Unknown |  |
| homepage | Unknown |  |
| imdb_id | Unknown |  |
| origin_country | Json |  |
| original_language | Unknown |  |
| original_title | Unknown |  |
| overview | Unknown |  |
| popularity | Unknown |  |
| poster_path | Unknown |  |
| release_date | Unknown |  |
| revenue | Unknown |  |
| runtime | Unknown |  |
| status | Unknown |  |
| tagline | Unknown |  |
| title | Unknown |  |
| video | Unknown |  |
| vote_average | Unknown |  |
| vote_count | Unknown |  |

## Relationships

- tv_series_video(tv_series_id) → tv_series(id)
- tv_series_language(tv_series_id) → tv_series(id)
- tv_series_created_by(tv_series_id) → tv_series(id)
- tv_series_genre(tv_series_id) → tv_series(id)
- tv_series_network(tv_series_id) → tv_series(id)
- tv_series_production_company(tv_series_id) → tv_series(id)
- tv_series_production_country(tv_series_id) → tv_series(id)
- tv_series_season(tv_series_id) → tv_series(id)
- tv_series_spoken_language(tv_series_id) → tv_series(id)
- movie_video(movie_id) → movie(id)
- movie_genre(movie_id) → movie(id)
- movie_production_company(movie_id) → movie(id)
- movie_production_country(movie_id) → movie(id)
- movie_spoken_language(movie_id) → movie(id)