Ledger Nano X - The secure hardware wallet
SHARE
TWEET

Untitled

a guest Mar 28th, 2020 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE "programmer" (
  2.     "id" INT GENERATED AS IDENTITY NOT NULL PRIMARY KEY,
  3.     "github" VARCHAR(255) NOT NULL,
  4.     "admin" SMALLINT DEFAULT 0 NOT NULL
  5. );
  6.  
  7. CREATE TABLE "user" (
  8.     "id" INT GENERATED AS IDENTITY NOT NULL PRIMARY KEY,
  9.     "first_name" VARCHAR(80) NOT NULL,
  10.     "last_name" VARCHAR(80) NOT NULL,
  11.     "birthdate" DATE DEFAULT NULL,
  12.     "email" VARCHAR(255) NOT NULL
  13.         CHECK(REGEXP_LIKE(
  14.             "email", '^[a-z]+[a-z0-9\.]*@[a-z0-9\.-]+\.[a-z]{2,}$', 'i'
  15.         )),
  16.     "password" VARCHAR(255) NOT NULL,
  17.     "programmer_id" INT DEFAULT NULL,
  18.     CONSTRAINT "user_programmer_id_fk"
  19.         FOREIGN KEY ("programmer_id") REFERENCES "programmer" ("id")
  20.         ON DELETE SET NULL
  21. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top