create_citier_view
overwrite parent's type column when both tables have type column