dump.sql

CREATE DOMAIN class AS varchar(3) CHECK (VALUE ~* '[T]{1}\d{1,2}');

CREATE TABLE "questions" (
	"id" serial NOT NULL,
	"user_id" integer NOT NULL,
	"question" varchar(7000) NOT NULL,
	"points" integer NOT NULL DEFAULT '1',
	"tags" varchar(255) NOT NULL,
	"answered" boolean NOT NULL DEFAULT false,
	"submit_at" TIMESTAMP NOT NULL DEFAULT now(),
	CONSTRAINT "questions_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "users" (
	"id" serial NOT NULL,
	"name" varchar(255) NOT NULL,
	"class" class NOT NULL,
	CONSTRAINT "users_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

CREATE TABLE "answers" (
	"id" serial NOT NULL,
	"user_id" integer NOT NULL,
	"question_id" integer NOT NULL,
	"answer" varchar(255) NOT NULL,
	"answeredAt" TIMESTAMP NOT NULL DEFAULT now(),
	CONSTRAINT "answers_pk" PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);

ALTER TABLE "questions" ADD CONSTRAINT "questions_fk0" FOREIGN KEY ("user_id") REFERENCES "users"("id");
ALTER TABLE "answers" ADD CONSTRAINT "answers_fk0" FOREIGN KEY ("user_id") REFERENCES "users"("id");
ALTER TABLE "answers" ADD CONSTRAINT "answers_fk1" FOREIGN KEY ("question_id") REFERENCES "questions"("id");