introduced deletable role column with left outer join query