drop table resume.contactinfo cascade;

create table resume.contactinfo (
    id serial8 primary key,
    user_id bigint not null references auth.users(id),
    address character varying(255) not null,
    city character varying(255) not null,
    state_id bigint not null references resume.states(id),
    phone character varying(255) not null,
    email character varying(255) not null,
    url character varying(255) not null,
    visastatus_id bigint not null references resume.visastatus(id)
);