create table customer
        (
        customer_num            serial(101),
        fname                   char(15),
        lname                   char(15),
        company                 char(20),
        address1                char(20),
        address2                char(20),
        city                    char(15),
        state                   char(2),
        zipcode                 char(5),
        phone                   char(18),
       primary key (customer_num)
        );
