drop view resume.contactinfo_v cascade;

create or replace view resume.contactinfo_v as
select c.id,
    c.user_id,
    c.address,
    c.city,
    c.state_id,
    s.state as state_name,
    s.abbr as state_abbr,
    c.phone,
    c.email,
    c.visastatus_id,
    v.status as visastatus
from resume.contactinfo c
inner join resume.states s on c.state_id = s.id
inner join resume.visastatus v on c.visastatus_id = v.id;