Use SQLAlchemy cascades for deleting objects
This MR:
- specifies cascades in the database schema for deletion of children
- adds test for the specified cascades
- updates the code to use cascade deletion
Closes #308 (closed)
This MR:
Closes #308 (closed)