All threads / Incorrect setup for Model associations

Ask A Question

Notifications

You’re not receiving notifications from this thread.

Incorrect setup for Model associations

Masud Hossain asked in Databases

I feel these associations are incorrectly set up. It's a bit similar to Trello, except I'm adding in a 'client' model too. The main part that's confusing to me is the fact user.rb, it's just bugging me.

https://docs.google.com/spreadsheets/d/17HLjRnIrs-lf_nNwJKj3ijkC2HnfEmti2wVFdx6kG9Y/edit?usp=sharing

What it's suppose to do:

  1. A user can create a business and belong to it as an employee.
  2. A business can have multiple employees (and a user belongs to that specific employee).
  3. A business can have multiple clients (and a user belongs to that specific client).

Is there a more efficient way to set this up?

@Tabish Iqbal,

do you mind showing me how the models would be set up? I don't seem to understand how the self joins would work in this case.

Join the discussion

Want to stay up-to-date with Ruby on Rails?

Join 34,885+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    logo Created with Sketch.

    Ruby on Rails tutorials, guides, and screencasts for web developers learning Ruby, Rails, Javascript, Turbolinks, Stimulus.js, Vue.js, and more. Icons by Icons8

    © 2020 GoRails, LLC. All rights reserved.