Foreign key referencing nonprimary key

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?

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.

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.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs