update
fix external assoications table
more user views