5

I am doing a coding project in rails. I have a user model, and I want to add a "spouse_id" to it (which would reference other users). Can a model reference itself in a foreign key?

Improve this question
6
  • What is the data store, for those of us not familiar with Rails? In some data stores, joins of any kind are problematic, and Rails is not the issue. Commented Jul 24, 2015 at 14:39
  • I'm not sure what you mean, but I am storing the data in a database (sqlite3 in dev; postgres in prod) Commented Jul 24, 2015 at 14:40
  • 2
    Then the answer is "of course." It's called a self-join. Commented Jul 24, 2015 at 14:40
  • 1
    Thanks @RobertHarvey, I'm still new at this, never heard of a self-join. Now that I know what to look for: railscasts.com/episodes/163-self-referential-association Commented Jul 24, 2015 at 14:41
  • 2
    Also called a Self-referencing table. Commented Jul 24, 2015 at 14:42

2 Answers 2

Reset to default
3

Thanks to the comments:

Then the answer is "of course." It's called a self-join.

Improve this answer
2

For those who are still looking for the how-to in Rails.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.