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

-- Table: cites
CREATE TABLE "bird__citeseer"."cites" (
    "cited_paper_id" TEXT NOT NULL,
    "citing_paper_id" TEXT NOT NULL,
    CONSTRAINT "cites_pkey" PRIMARY KEY ("cited_paper_id", "citing_paper_id")
);

-- Table: content
CREATE TABLE "bird__citeseer"."content" (
    "paper_id" TEXT NOT NULL,
    "word_cited_id" TEXT NOT NULL,
    CONSTRAINT "content_pkey" PRIMARY KEY ("paper_id", "word_cited_id")
);

-- Table: paper
CREATE TABLE "bird__citeseer"."paper" (
    "paper_id" TEXT NOT NULL,
    "class_label" TEXT NOT NULL,
    CONSTRAINT "paper_pkey" PRIMARY KEY ("paper_id")
);

-- Foreign Keys
ALTER TABLE "bird__citeseer"."content" ADD CONSTRAINT "fk_content_0" FOREIGN KEY ("paper_id") REFERENCES "bird__citeseer"."paper" ("paper_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
