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

-- Table: Method
CREATE TABLE "bird__codebase_comments"."Method" (
    "Id" BIGINT NOT NULL,
    "Name" TEXT,
    "FullComment" TEXT,
    "Summary" TEXT,
    "ApiCalls" TEXT,
    "CommentIsXml" BIGINT,
    "SampledAt" BIGINT,
    "SolutionId" BIGINT,
    "Lang" TEXT,
    "NameTokenized" TEXT,
    CONSTRAINT "Method_pkey" PRIMARY KEY ("Id")
);

-- Table: MethodParameter
CREATE TABLE "bird__codebase_comments"."MethodParameter" (
    "Id" BIGINT NOT NULL,
    "MethodId" TEXT,
    "Type" TEXT,
    "Name" TEXT,
    CONSTRAINT "MethodParameter_pkey" PRIMARY KEY ("Id")
);

-- Table: Repo
CREATE TABLE "bird__codebase_comments"."Repo" (
    "Id" BIGINT NOT NULL,
    "Url" TEXT,
    "Stars" BIGINT,
    "Forks" BIGINT,
    "Watchers" BIGINT,
    "ProcessedTime" BIGINT,
    CONSTRAINT "Repo_pkey" PRIMARY KEY ("Id")
);

-- Table: Solution
CREATE TABLE "bird__codebase_comments"."Solution" (
    "Id" BIGINT NOT NULL,
    "RepoId" BIGINT,
    "Path" TEXT,
    "ProcessedTime" BIGINT,
    "WasCompiled" BIGINT,
    CONSTRAINT "Solution_pkey" PRIMARY KEY ("Id")
);
