I know the firebase is NoSQL / NoREL, but I have this doubt and it is very relevant given the project I am developing.
In the traditional MySQL model, when we have a categorias table, for example, and a posts table, and there is a relationship between them, a category that has posts tied to it can not usually be deleted. p>
How this is done in Firebase, since any document can be deleted. And if the category is deleted, what is the "orphan" post?
I would like to better understand how this works, as I am used to the relational model and am having difficulties at that point with NoSQL banks.
NOTE: I'm using Firestore, which is currently a BETA version.