James Mansion wrote:
> I was wondering whether one could try to identify what might be termed
> 'enum tables' that exist to provide lookups.
>
> There are perhaps three main types of table that is the target of a
> foreign key lookup:
>
> 1) tables that map to program language enumerations: typically small
> (less than a hundred rows) and changing very infrequently.
>
>
8.3's enum types will help with these, and they get you out of the FK
game altogether.
cheers
andrew