CREATE OR REPLACE VIEW person
AS
SELECT CONCAT_WS(' ', name_first, name_last) as name,
       student_id as student_id,
       Null as teacher_id,
       enrollment_id
FROM student

UNION  ALL

SELECT full_name as name,
       Null as student_id,
       id as teacher_id,
       enrollment_id
FROM teacher
;