If I use STI, I'll have several nil columns on my DB and I don't know if I can use Polymorphic Associations in cases like that. Any tip or some references?
[!How the right way to modeling somethink like that?] [1][1]
4
-
Why do you have nil columns? For which of the models in the image do you consider STI or Polymorphoc Associations?spickermann– spickermann2020-03-25 16:55:38 +00:00Commented Mar 25, 2020 at 16:55
-
Cause if I create a main class with all attributes, theres a child classes that doesn't needs all attributes, then in that classes, these attributes will be nil.Dok Nabaku– Dok Nabaku2020-03-25 19:49:58 +00:00Commented Mar 25, 2020 at 19:49
-
But looking at your datamodel both junior and senior have the exact same attributes. What columns do you expect to be nil?spickermann– spickermann2020-03-25 21:00:26 +00:00Commented Mar 25, 2020 at 21:00
-
Im talking about classes before junior and senior. The classe Employee(junior and senior) in not a problem. The problem is the classes before that contains the same attributes and one more. How I design that classes without repeat the same attributes in all that? For example, classes Lider and Coordenador have the same attributes and one more.Dok Nabaku– Dok Nabaku2020-03-28 17:57:02 +00:00Commented Mar 28, 2020 at 17:57
Add a comment
|
1 Answer
Though I don't understand the language completely from the image. If I understand I think one Coordinator has many Junior employee and senior employee. And seems like both employee table has the same type of column. What I would do in this case is, I would just create one employee table and keep a enum column of role. The model would look something like below-
class Coordinator
has_many: :employees
end
class Employee
belongs_to: :coordinator
enum role: { junior: 0, senior: 1 }
end
If you haven't used enum in Rails yet, it's really handy. Take a look
1 Comment
Dok Nabaku
The problem is not Cordinator class, its ok. The problem is with the classes before that contains the same attributes with one or two more. How can I design it without repeat all attributes in every class?