TV Shows
A full, 3NF database that about current TV Shows (Approximately 160K Shows)
@kaggle.denizbilginn_tv_shows
A full, 3NF database that about current TV Shows (Approximately 160K Shows)
@kaggle.denizbilginn_tv_shows
CREATE TABLE networks (
"show_id" BIGINT,
"network_type_id" BIGINT
);
CREATE TABLE genres (
"show_id" BIGINT,
"genre_type_id" BIGINT
);
CREATE TABLE origin_country_types (
"origin_country_type_id" BIGINT,
"origin_country_name" VARCHAR
);
CREATE TABLE spoken_language_types (
"spoken_language_type_id" BIGINT,
"spoken_language_name" VARCHAR
);
CREATE TABLE language_types (
"language_type_id" BIGINT,
"language_name" VARCHAR
);
CREATE TABLE genre_types (
"genre_type_id" BIGINT,
"genre_name" VARCHAR
);
CREATE TABLE production_company_types (
"production_company_type_id" BIGINT,
"production_company_name" VARCHAR
);
CREATE TABLE production_countries (
"show_id" BIGINT,
"production_country_type_id" BIGINT,
"origin_country_type_id" BIGINT
);
CREATE TABLE production_companies (
"show_id" BIGINT,
"production_company_type_id" BIGINT
);
CREATE TABLE created_by (
"show_id" BIGINT,
"created_by_type_id" BIGINT
);
CREATE TABLE status (
"status_id" BIGINT,
"status_name" VARCHAR
);
CREATE TABLE spoken_languages (
"show_id" BIGINT,
"spoken_language_type_id" BIGINT
);
CREATE TABLE show_votes (
"vote_count" BIGINT,
"vote_average" DOUBLE,
"show_id" BIGINT
);
CREATE TABLE production_country_types (
"production_country_type_id" BIGINT,
"production_country_name" VARCHAR
);
CREATE TABLE air_dates (
"is_first" BIGINT,
"show_id" BIGINT,
"date" TIMESTAMP
);
CREATE TABLE created_by_types (
"created_by_type_id" BIGINT,
"created_by_name" VARCHAR
);
CREATE TABLE languages (
"show_id" BIGINT,
"language_type_id" BIGINT
);
CREATE TABLE links (
"link_type_id" BIGINT,
"show_id" BIGINT,
"link" VARCHAR
);
CREATE TABLE shows (
"show_id" BIGINT,
"name" VARCHAR,
"number_of_seasons" BIGINT,
"number_of_episodes" BIGINT,
"overview" VARCHAR,
"adult" BIGINT,
"in_production" BIGINT,
"original_name" VARCHAR,
"popularity" DOUBLE,
"tagline" VARCHAR,
"eposide_run_time" BIGINT,
"type_id" BIGINT,
"status_id" BIGINT
);
CREATE TABLE network_types (
"network_type_id" BIGINT,
"network_name" VARCHAR
);
CREATE TABLE types (
"type_id" BIGINT,
"type_name" VARCHAR
);
CREATE TABLE link_types (
"link_type_id" BIGINT,
"link_type" VARCHAR
);
Anyone who has the link will be able to view this.