I've got a chat app I'm working on, and I don't undertand very well what relationships I should be using. Here's the setup:
/ Folder 1 \
Account > Mailbox >- Folder 2 - > Message
\ Folder 3 /
As you can see, I'll have a lot of messages, but only one of each of the other entities. What relationships should I set up here so that when a Account
is deleted, it will delete everything going down the line as well? Of course when a message is deleted, it shouldn't delete the account. Ideas?