Listing 1. Creating a Simple Table

CREATE TABLE People (
    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)
);