By definition, a FK has to reference a PK in the “parent”. | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ak39 6 months ago \| parent \| context \| favorite \| on: How to Get Foreign Keys Horribly Wrong By definition, a FK has to reference a PK in the “parent”.

aidos 6 months ago [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact