From 8ab94f4677f8d56655a45bb636917429dcddda24 Mon Sep 17 00:00:00 2001 From: ckonstanski Date: Mon, 20 Jul 2026 21:09:54 -0600 Subject: got contact info working --- sql/views/resume.contactinfo_v.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/views/resume.contactinfo_v.sql (limited to 'sql/views/resume.contactinfo_v.sql') diff --git a/sql/views/resume.contactinfo_v.sql b/sql/views/resume.contactinfo_v.sql new file mode 100644 index 0000000..4c4eb79 --- /dev/null +++ b/sql/views/resume.contactinfo_v.sql @@ -0,0 +1,17 @@ +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; -- cgit v1.3