On Fri, May 22, 2009 at 10:38 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Fri, May 22, 2009 at 4:10 PM, Benjamin Smith
> <lists@benjamindsmith.com> wrote:
>>
>> Is there a better way?
>
> Yeah, natural keys.
+1.
Also, what Ben described reeks of EAV.
Ben, please read:
http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html
... and avoid traveling down that (ugly) path.
Good luck.