added all views we need for a user to query the database.