Skip to content

Instantly share code, notes, and snippets.

@JamieKalloe

JamieKalloe/IPSENH Studievolg database

Created April 18, 2017 09:03
Show Gist options
  • Save JamieKalloe/db161ad99059a6140bd80e9bd797b2b6 to your computer and use it in GitHub Desktop.
Save JamieKalloe/db161ad99059a6140bd80e9bd797b2b6 to your computer and use it in GitHub Desktop.
Download ZIP
IPSENH-DB.sql
Raw
IPSENH Studievolg database
CREATE TABLE User_account (
id SERIAL,
first_name VARCHAR(255) NOT NULL,
insertion VARCHAR(255),
last_name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
date_of_birth DATE NOT NULL,
password VARCHAR(255) NOT NULL,
role VARCHAR(255) NOT NULL,
CONSTRAINT pk_id PRIMARY KEY (id),
CONSTRAINT uni_email UNIQUE (email)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment