Looking for some guidance on how to accomplish the following…
Assume a ticket management system being developed, with a main Ticket
A Ticket has:
an assigned resource
an escalation manager
one or more copy-to’s
All of these are just different people from my users table.
Any one person in the user table could be any one of these on one or
more tickets. That is, I could be the caller on one or more tickets, or
the assigned resource or the copy-to.
The same person could be one or more of these on any one ticket. That
is, I could be both the assigned resource and the closer on a particular
I’m not sure how to do this within Rails, without creating multiple
tables and/or views. It’s not really polymorphic, as I understand it.
It’s not really STI, as I that. It’s kind of a hybrid. Can it be done
just by setting up the right associations with appropriate parms (like
:source, :foreign_key, :class_name)?
Just need to be set in the right direction and given a good push…