huimv-baqing/sql/biz_v_agricultural_course.sql

create or replace view v_agricultural_course as
select id,resource_name as title,introduction,course_topic as type,cover_file_url,video_file_url as content_file_url,publish_time,null as actual_enrolled_count,null as planned_head_count,null as registration_start_time,null as registration_end_time,null as training_time,null as expected_outcome from biz_tech_resource where del_flag='0' and publish_status=1 and resource_type='004008'
UNION ALL
select id,training_topic as title,training_intro as introduction,training_status as type,cover_file_url,null as content_file_url,publish_time,actual_enrolled_count,planned_head_count,registration_start_time,registration_end_time,training_time,expected_outcome from biz_practical_training where del_flag='0' and publish_status=1;