create view actor as 
   select person_id, movie_id, character, position, note
   from credits 
   where type = 'actor' ;

create view writer as 
   select person_id, movie_id, line_order, group_order, subgroup_order, note
   from credits 
   where type = 'writer' ;

create view editor as 
   select person_id, movie_id, note
   from credits 
   where type = 'editor' ;

create view director as 
   select person_id, movie_id, note
   from credits 
   where type = 'director' ;

create view cinematographer as 
   select person_id, movie_id, note
   from credits 
   where type = 'cinematographer' ;

create view composer as 
   select person_id, movie_id, note
   from credits 
   where type = 'composer' ;

create view costume_designer as 
   select person_id, movie_id, note
   from credits 
   where type = 'costume_designer' ;

create view producer as 
   select person_id, movie_id, note
   from credits 
   where type = 'producer' ;