CREATE TABLE People (<\n> person_id SERIAL NOT NULL, name VARCHAR(40) NOT NULL, address1 VARCHAR(30) NULL, address2 VARCHAR(30) NULL, email VARCHAR(50) NOT NULL, city VARCHAR(30) NULL, state VARCHAR(2) NULL, zip VARCHAR(10) NULL, PRIMARY KEY(person_id), UNIQUE(name) );