Subject Re: [ib-support] Db Design opinions sought - Lookup tables and surrogate PKs
Author Raul Chirea

From: "Frank Ingermann" <frank@...>

> imho it strongly depends on how the lookups will be used - there's pro's
> con's to both approaches:

Yes. For example, it would be amusing (not to say really stupid) to make a
"countries" table having "country_code", "country_name" fields and an
integer "id" as the PK when "country_code" can be used very well as a PK and
also it has a meaning.