22 lines
598 B
SQL
22 lines
598 B
SQL
CREATE TABLE "public"."User" (
|
|
id SERIAL PRIMARY KEY NOT NULL,
|
|
name VARCHAR(255),
|
|
email VARCHAR(255) UNIQUE NOT NULL
|
|
);
|
|
|
|
CREATE TABLE "public"."Post" (
|
|
id SERIAL PRIMARY KEY NOT NULL,
|
|
title VARCHAR(255) NOT NULL,
|
|
"createdAt" TIMESTAMP NOT NULL DEFAULT now(),
|
|
content TEXT,
|
|
published BOOLEAN NOT NULL DEFAULT false,
|
|
"authorId" INTEGER NOT NULL,
|
|
FOREIGN KEY ("authorId") REFERENCES "public"."User"(id)
|
|
);
|
|
|
|
CREATE TABLE "public"."Profile" (
|
|
id SERIAL PRIMARY KEY NOT NULL,
|
|
bio TEXT,
|
|
"userId" INTEGER UNIQUE NOT NULL,
|
|
FOREIGN KEY ("userId") REFERENCES "public"."User"(id)
|
|
); |