Handle cameras deletion cascade for poses, sequences, detections, and storage cleanup

[fe51]

Pitch

Same consideration as #541 Handle organization deletion cascade for cameras, sequences, detections, and storage cleanup

Moreover, camera deletion endpoint return a 500 !

Needs cascade deletion, and would be relevant to handle this issue as FG suggested it in 541

1. for postgres cascade deletion we use native postgres features (cf. cascade delete)
2. once that's done, we can handle blob deletion (bucket objects)

Thanks a lot 🙏