[Tfug] Any SQL gurus out there?

[Tim Ottinger]

ie the "domain" of the entity. :-)

yes, reference data should be there, and should be managed.
If you think it never changes, then put the insert statements into the
database creation script.


On 10/25/07, Claude Rubinson <rubinson at u.arizona.edu> wrote:
>
> On Thu, Oct 25, 2007 at 02:23:55PM -0700, Don Freeman wrote:
> > Maybe we're discussing only semantics. Are you suggesting that a
> > lookup table for example should not be part of the database?
>
> Lookup tables should definitely be part of the database.  And the
> tables that reference a given lookup table should have referential
> integrity to said lookup table.  A lookup table doesn't stand alone.
>
> Another way to think about it: a lookup table defines the possible
> instances of an entity.
>
>