-- Schema: bird__disney
CREATE SCHEMA IF NOT EXISTS "bird__disney";

-- Table: characters
CREATE TABLE "bird__disney"."characters" (
    "movie_title" TEXT NOT NULL,
    "release_date" TEXT,
    "hero" TEXT,
    "villian" TEXT,
    "song" TEXT,
    CONSTRAINT "characters_pkey" PRIMARY KEY ("movie_title")
);

-- Table: director
CREATE TABLE "bird__disney"."director" (
    "name" TEXT NOT NULL,
    "director" TEXT,
    CONSTRAINT "director_pkey" PRIMARY KEY ("name")
);

-- Table: movies_total_gross
CREATE TABLE "bird__disney"."movies_total_gross" (
    "movie_title" TEXT NOT NULL,
    "release_date" TEXT NOT NULL,
    "genre" TEXT,
    "MPAA_rating" TEXT,
    "total_gross" TEXT,
    "inflation_adjusted_gross" TEXT,
    CONSTRAINT "movies_total_gross_pkey" PRIMARY KEY ("movie_title", "release_date")
);

-- Table: revenue
CREATE TABLE "bird__disney"."revenue" (
    "Year" BIGINT NOT NULL,
    "Studio Entertainment[NI 1]" DOUBLE PRECISION,
    "Disney Consumer Products[NI 2]" DOUBLE PRECISION,
    "Disney Interactive[NI 3][Rev 1]" BIGINT,
    "Walt Disney Parks and Resorts" DOUBLE PRECISION,
    "Disney Media Networks" TEXT,
    "Total" BIGINT,
    CONSTRAINT "revenue_pkey" PRIMARY KEY ("Year")
);

-- Table: voice-actors
CREATE TABLE "bird__disney"."voice-actors" (
    "character" TEXT NOT NULL,
    "voice-actor" TEXT,
    "movie" TEXT,
    CONSTRAINT "voice-actors_pkey" PRIMARY KEY ("character")
);
