summaryrefslogtreecommitdiff
path: root/sql/tables/resume.contactinfo.sql
blob: 7a89fb7778fb6525287980eb4f5ba3d669ca1cb0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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)
);