Foreign key referencing nonprimary key

Rails
1

In a legacy schema sometimes we may discover foreign key constraints
that don’t follow the simple “FK references PK” rule, but “FK references
UNIQUE column” rule. Is there a way to mapping this with :foreing_key=>
… or some other mechanism with ActiveRecord?

2

On Sep 13, 5:27am, Vogon P. [email protected] wrote:

In a legacy schema sometimes we may discover foreign key constraints
that don’t follow the simple “FK references PK” rule, but “FK references
UNIQUE column” rule. Is there a way to mapping this with :foreing_key=>
… or some other mechanism with ActiveRecord?

You’ll want to specify the relevant field (on both the has_many and
belongs_to) by passing the :primary_key option.

–Matt J.

3

Matt J. wrote in post #1021972:

On Sep 13, 5:27am, Vogon P. [email protected] wrote:

In a legacy schema sometimes we may discover foreign key constraints
that don’t follow the simple “FK references PK” rule, but “FK references
UNIQUE column” rule. Is there a way to mapping this with :foreing_key=>
… or some other mechanism with ActiveRecord?

You’ll want to specify the relevant field (on both the has_many and
belongs_to) by passing the :primary_key option.

–Matt J.

Thank you Matt, this is the option that i needed.