O'Reilly logo
  • Shayne Riley thinks this is interesting:

Relationships:

Referential integrity constraints implement dependencies between tables, but this might not tell everything that you intend the constraints to model.

From

Cover of SQL Antipatterns

Note

In some cases, you may have implicit relationships but no constraints for them. Without documentation, it's hard to know where the relationships exist.