create or replace view v_themes as
select
	themes.id,
    themes.course_id,
    courses.name as course_name,
    themes.name,
    themes.tags,
    themes.evaluable,
    themes.status
from themes
join courses on courses.id = themes.course_id;
