News for hackers. Stuff that matters.

A comment on How to Get Foreign Keys Horribly Wrong. Parent comment

Re:How to Get Foreign Keys Horribly Wrong by ak39 on Friday July 18, 2025 @06:00PM (#44610282)
By definition, a FK has to reference a PK in the “parent”.
[ Parent | on HN ]
Re:How to Get Foreign Keys Horribly Wrong by aidos on Friday July 18, 2025 @07:20PM (#44610905)
Not quite. It can reference any combination of columns with a unique index (of with the PK is by definition).
[ Parent | on HN ]