Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Schema Question

Status
Not open for further replies.

jtrembla

ISP
Jul 6, 2006
104
US
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.
 
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top