Schema Question

[jtrembla]

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.

 

[RiverGuy]

Well, if you have foreign keys to the AdjustmentTypes tables, if you combine both into one table, what's to stop an application one day from accidentally selecting a PopulationAdjustmentType for a Drug Adjustment record?

 

[jtrembla]

A smart programmer, lol.