Hacker News new | ask | show | jobs
by ak39 328 days ago
By definition, a FK has to reference a PK in the “parent”.
1 comments

Not quite. It can reference any combination of columns with a unique index (of with the PK is by definition).