modified to more views and refactored the db to add status field