select person_id,
       movie_id,
       'actor' as type,
       note,
       character,
       position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from actor
union 
select person_id,
       movie_id,
       'writer' as type,
       note,
       null as character,
       null as position,
       line_order,
       group_order,
       subgroup_order
from writer
union 
select person_id,
       movie_id,
       'editor' as type,
       note,
       null as character,
       null as position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from editor
union
select person_id,
       movie_id,
       'director' as type,
       note,
       null as character,
       null as position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from director
union
select person_id,
       movie_id,
       'cinematographer' as type,
       note,
       null as character,
       null as position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from cinematographer
union
select person_id,
       movie_id,
       'composer' as type,
       note,
       null as character,
       null as position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from composer
union
select person_id,
       movie_id,
       'costume_designer' as type,
       note,
       null as character,
       null as position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from costume_designer
union
select person_id,
       movie_id,
       'producer' as type,
       note,
       null as character,
       null as position,
       null as line_order,
       null as group_order,
       null as subgroup_order
from producer
order by person_id, movie_id, type, note, character, position, line_order, group_order, subgroup_order;