20 lines
557 B
SQL
20 lines
557 B
SQL
-- CreateTable
|
|
CREATE TABLE "educations" (
|
|
"id" UUID NOT NULL,
|
|
"institution" TEXT NOT NULL,
|
|
"degree" TEXT NOT NULL,
|
|
"field_of_study" TEXT NOT NULL,
|
|
"location" TEXT,
|
|
"start_year" INTEGER NOT NULL,
|
|
"end_year" INTEGER,
|
|
"is_ongoing" BOOLEAN NOT NULL DEFAULT false,
|
|
"description" TEXT,
|
|
"gpa" TEXT,
|
|
"final_project_title" TEXT,
|
|
"final_project_url" TEXT,
|
|
"order" INTEGER NOT NULL DEFAULT 0,
|
|
"created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "educations_pkey" PRIMARY KEY ("id")
|
|
);
|