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

-- Table: actor
CREATE TABLE "spider__musical"."actor" (
    "Actor_ID" BIGINT NOT NULL,
    "Name" TEXT,
    "Musical_ID" BIGINT,
    "Character" TEXT,
    "Duration" TEXT,
    "age" BIGINT,
    CONSTRAINT "actor_pkey" PRIMARY KEY ("Actor_ID")
);

-- Table: musical
CREATE TABLE "spider__musical"."musical" (
    "Musical_ID" BIGINT NOT NULL,
    "Name" TEXT,
    "Year" BIGINT,
    "Award" TEXT,
    "Category" TEXT,
    "Nominee" TEXT,
    "Result" TEXT,
    CONSTRAINT "musical_pkey" PRIMARY KEY ("Musical_ID")
);

-- Foreign Keys
ALTER TABLE "spider__musical"."actor" ADD CONSTRAINT "fk_actor_0" FOREIGN KEY ("Musical_ID") REFERENCES "spider__musical"."actor" ("Actor_ID") ON DELETE NO ACTION ON UPDATE NO ACTION;
