add dependency delete to sensor record association

to prevent database junk
fix missing create resource