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

-- Table: Author
CREATE TABLE "bird__authors"."Author" (
    "Id" BIGINT NOT NULL,
    "Name" TEXT,
    "Affiliation" TEXT,
    CONSTRAINT "Author_pk" PRIMARY KEY ("Id")
);

-- Table: Conference
CREATE TABLE "bird__authors"."Conference" (
    "Id" BIGINT NOT NULL,
    "ShortName" TEXT,
    "FullName" TEXT,
    "HomePage" TEXT,
    CONSTRAINT "Conference_pk" PRIMARY KEY ("Id")
);

-- Table: Journal
CREATE TABLE "bird__authors"."Journal" (
    "Id" BIGINT NOT NULL,
    "ShortName" TEXT,
    "FullName" TEXT,
    "HomePage" TEXT,
    CONSTRAINT "Journal_pk" PRIMARY KEY ("Id")
);

-- Table: Paper
CREATE TABLE "bird__authors"."Paper" (
    "Id" BIGINT NOT NULL,
    "Title" TEXT,
    "Year" BIGINT,
    "ConferenceId" BIGINT,
    "JournalId" BIGINT,
    "Keyword" TEXT,
    CONSTRAINT "Paper_pkey" PRIMARY KEY ("Id")
);

-- Table: PaperAuthor
CREATE TABLE "bird__authors"."PaperAuthor" (
    "PaperId" BIGINT,
    "AuthorId" BIGINT,
    "Name" TEXT,
    "Affiliation" TEXT
);
