Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement