create or replace view v_workshops as
select
	workshops.id,
    workshops.city_id,
    cities.name as city_name,
    workshops.program_id,
    programs.name as program_name,
    workshops.name,
    workshops.date,
    workshops.status
from workshops
join cities on cities.id = workshops.city_id
join programs on programs.id = workshops.program_id;
