summaryrefslogtreecommitdiff
path: root/sql/tables/resume.contactinfo.sql
blob: 8523270077171d1ca5aa8971aebd4b26fbb21f0f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
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,
    visastatus_id bigint not null references resume.visastatus(id)
);