sql/tables/resume.contactinfo.sql


1
2
3
4
5
6
7
8
9
10
11

drop table resume.contactinfo cascade;

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