Foreign key must reference a PK or a unique constraint in the parent. Since your secondary "key" is not a key at all, because it will contain non-unique values, you will have to deal with that as well.