customerid bigserial NOT NULL,
account varchar(75) NOT NULL,
firstname varchar(75) NOT NULL,
lastname varchar(75) NOT NULL,
phone varchar(15),
email varchar(255) NOT NULL,
username varchar(50) NOT NULL,
passwd varchar(20),
prepaid int2 NOT NULL DEFAULT 1,
inuse int2 NOT NULL DEFAULT 0,
active int2 NOT NULL DEFAULT 1,
company varchar(150),
address1 varchar(75) NOT NULL,
address2 varchar(75),
city varchar(75) NOT NULL,
state varchar(50) NOT NULL,
zipcode varchar(15) NOT NULL,
country varchar(3) NOT NULL,
createdate timestamp NOT NULL DEFAULT ('now'::text)::timestamp(6) with time zone,
samebilling int2 DEFAULT 0,
referral varchar(150),
salesrepid int8 DEFAULT 0,
deleted int2 DEFAULT 0,
CONSTRAINT pk_customerid PRIMARY KEY (customerid)