-- CreateTable
CREATE TABLE "Commission" (
    "id" TEXT NOT NULL,
    "name" VARCHAR(250) NOT NULL,
    "description" TEXT NOT NULL,

    CONSTRAINT "Commission_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "Mandate" (
    "id" TEXT NOT NULL,
    "name" VARCHAR(250) NOT NULL,

    CONSTRAINT "Mandate_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "College" (
    "id" TEXT NOT NULL,
    "name" VARCHAR(250) NOT NULL,

    CONSTRAINT "College_pkey" PRIMARY KEY ("id")
);