added various asset status tables and routes