added initial sql and wireframe for bad status item management