Re: Physical Database Design - Code Tables
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Tue, 21 Nov 2006 15:29:35 -0600
Paula,
One issue I don't see mentioned is the number of columns. In my experience,
some codes tables have a different number of columns than others, and those
columns may have different properties (data type, column name, etc.). If you
use a single codes table, then all codes must have the same columns. If at a
later point, some codes are found to need an additional column, then all
codes will get the added column. If you add that column, then you have to
hope that all the application code will be unaffected. This isn't probably a
big deal, but I think it points to the non-normalized situation that a
shared code table gets you into.
Dennis Williams
Other related posts:
