I have a collection that contains multiple documents in a one to many relationship.
When I delete the main document even with the cascade deletion rule on the document doesn't delete.
The sub collection documents remain there.
TL;DR
Issue: Sub-collection documents are not being deleted when the main document is deleted despite having the cascade deletion rule activated.
Solution: The cascade deletion rule needs to be applied at the database level for sub-collection documents to be deleted automatically when the main document is deleted in a one-to-many relationship.