Re:A terrible schema from a clueless programmer
by tremon on Monday November 08, 2021 @12:47PM
(#29151952)
I don't buy that reason, because that inconsistency can be easily prevented with good schema hygiene (either ON DELETE NO ACTION or ON DELETE CASCADE). The problem is rather that in order to maintain consistent data relations, delete operations must be carefully designed and that part of the functional design is usually skipped because it's perceived as not important.
Which is more or less what the GP says as well, deletes are not implemented because doing it properly requires proper design.
Or in the case of Silicon Valley, leave everything in tact with a disabled flag and then spam you for the next decade or so.