cleaned up some views
made some links between tables