CREATE TABLE MyUser ( userName VARCHAR(12) PRIMARY KEY, password VARCHAR(20) NOT NULL, fullName VARCHAR(30) NOT NULL, isAdmin boolean NOT NULL DEFAULT False -- postgreSql specific datatype ); CREATE TABLE UserEmails ( userName VARCHAR(12) NOT NULL REFERENCES MyUser(userName), email VARCHAR(30) NOT NULL, CONSTRAINT UserEmails_PK PRIMARY KEY (userName,email) );