I have an entity consisting of several attributes (can be added, can be removed from entity - and new attributes made as well). I need to be able to store the values - so for example I have a list of Attribute / Value pairs . When assigning Attribute to Machine - the Machine also has a min max value for the Attribute - how can I structure the tables to create the proper relationship. Consider the following tables
- [Machine Table: MachId],
- [Machine_EAV Table: MachId, EavId, ?MinVal?, ?MaxVal?, ?Value?],
- [EAV Table: EavId, Name, TypeId] ,
- [Type Table: TypeId, TypeName]
In order to store values and have min and max Should I have a Table for the specific dataTypes like this: IntType_Attributes IntId, Machine_EAVId, MinVal, MaxVal, Value
If anyone needs more info I can add that just ask and I will do my best to provide. Note the Machine Parameters are constantly changing .. it needs to be flexible.
I am going to need to present a proper view as well - so I will need to be able create a view from the tables..