drop table resume.job cascade; create table resume.job ( id serial8 primary key, company character varying(255) not null, location character varying(255) not null, start_date timestamp without time zone not null default now(), end_date timestamp without time zone not null default now(), overview text );