User bio
404 bio not found
Member since Mar 22
Replies:

The list type of Organizations existed prior to the changes I am making and is in use within the application in other places. As such I was ideally hoping implement the cascade deletion without changing that type. However, a Parent/Child relationship as both you and @Iryna Mykhailova suggested is a great option for the automatic cascade deletion and I will definitely consider the benefits of that change. Thank you!

Thank you for the clarification. For the given situation, there would never exist multiple lists that hold the same organization object. Following your example, my tables would be as such. 

Organization
ID
1
2
3
4
5
GetOrgUpdatesResponse
ID Organizations
1 2
2 1,3
3 4,5

So that there would not exist a situation where a deletion of a list in GetOrgUpdatesResponse would result in any other list containing incorrect data. 

Followers:
Hannah has no followers yet.
Following:
Hannah has not followed anybody yet.
Global Masters badges: