A design specification for a corporate database application explicitly states that referential integrity constraints are 'not applicable' — with no explanation given. This pattern has appeared across multiple database-driven applications at the same company, suggesting someone is copy-pasting from an old spec without understanding the implications. The likely outcome: silent data corruption until something breaks in production.
Sort: