Subject | Db Design opinions sought - Lookup tables and surrogate PKs |
---|---|
Author | Rob Schuff |
Post date | 2002-07-25T20:38:33Z |
greetings folks,
we are having a spirited discussion at a work about lookup table and whether
or not they should have a surrogate primary (integer) or whether its better
to just use the lookup value (or an uppercase'd copy of it) as the primary
key. I personally have been on both sides of the fence before (normalize to
the max or be somewhat pragmatic). Anybody care to share their opinions?
rob
we are having a spirited discussion at a work about lookup table and whether
or not they should have a surrogate primary (integer) or whether its better
to just use the lookup value (or an uppercase'd copy of it) as the primary
key. I personally have been on both sides of the fence before (normalize to
the max or be somewhat pragmatic). Anybody care to share their opinions?
rob