Use FK etc to ensure referential integrity but don't use it for cascading deletes. Speaking of Finance industry, stuff gets seldom deleted and when it does, mor

Use FK etc to ensure referential integrity but don't use it for cascading deletes. Speaking of Finance industry, stuff gets seldom deleted and when it does, more often than not, it is either manually orchestrated or the same orchestration is done via code. Sure it's more work but you are in full control of what is being removed at each stage.