The Movie Database
Explore the interactive ERD
Table & Field Reference
tv_series_video
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tv_series_id | Unknown | PKFK |
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 | PKFK |
languages | Unknown |
tv_series_created_by
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tv_series_id | Unknown | PKFK |
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 | PKFK |
name | Unknown |
tv_series_network
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tv_series_id | Unknown | PKFK |
logo_path | Unknown | |
name | Unknown | |
origin_country | Unknown |
tv_series_production_company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tv_series_id | Unknown | PKFK |
logo_path | Unknown | |
name | Unknown | |
origin_country | Unknown |
tv_series_production_country
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
tv_series_id | Unknown | PKFK |
iso_3166_1 | Unknown | |
name | Unknown |
tv_series_season
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
tv_series_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown |
movie_production_company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
movie_id | Unknown | PKFK |
logo_path | Unknown | |
name | Unknown | |
origin_country | Unknown |
movie_production_country
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
movie_id | Unknown | PKFK |
iso_3166_1 | Unknown | |
name | Unknown |
movie_spoken_language
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
movie_id | Unknown | PKFK |
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 |