Database lookup tables and models

[eluser]Randy Casburn[/eluser]
@jleequeen - If the application is going to out live you, then consistency is important. I would recommend making all references to all data sources consistent. That way when someone replaces you (or you look back at this in three years long after you've forgotten why you did what you did), the consistency in your design will make learning or re-learning the design less painful. There may be a tiny performance hit here or there, but you will thank yourself ten times for doing things "consistently" down the road.

Just my 2c.

Randy