CREATE TABLE "programmer" (
	"id" INT GENERATED AS IDENTITY NOT NULL PRIMARY KEY,
	"github" VARCHAR(255) NOT NULL,
	"admin" SMALLINT DEFAULT 0 NOT NULL
);

CREATE TABLE "user" (
	"id" INT GENERATED AS IDENTITY NOT NULL PRIMARY KEY,
	"first_name" VARCHAR(80) NOT NULL,
	"last_name" VARCHAR(80) NOT NULL,
	"birthdate" DATE DEFAULT NULL,
	"email" VARCHAR(255) NOT NULL
		CHECK(REGEXP_LIKE(
			"email", '^[a-z]+[a-z0-9\.]*@[a-z0-9\.-]+\.[a-z]{2,}$', 'i'
		)),
	"password" VARCHAR(255) NOT NULL,
	"programmer_id" INT DEFAULT NULL,
	CONSTRAINT "user_programmer_id_fk"
		FOREIGN KEY ("programmer_id") REFERENCES "programmer" ("id")
		ON DELETE SET NULL
);