I currently have one table to hold ForecastAdjustmentTypes
Now each forecast adjustment are recorded differently.
Thus, attached to different schema.
For example some adjustments are done at the population level and some are done at the drug level.
Is it best practice to keep the type names in one table or should I have them in separate tables?
i.e.
DrugForecastAdjustmentType
PopulationForecastAdjustmentType
I suppose I could have all Type names tables throughout my database stored in one table, similar to the stringmap table in MSCRM.
Now each forecast adjustment are recorded differently.
Thus, attached to different schema.
For example some adjustments are done at the population level and some are done at the drug level.
Is it best practice to keep the type names in one table or should I have them in separate tables?
i.e.
DrugForecastAdjustmentType
PopulationForecastAdjustmentType
I suppose I could have all Type names tables throughout my database stored in one table, similar to the stringmap table in MSCRM.