deleting a venue causes venue foreign key fields to be set to null. closes #74