Re: [Gnumed-devel] basic test types

[J Busser]

At 1:29 AM -0700 9/29/04, J Busser wrote:
> At 8:26 AM +0200 9/29/04, Karsten Hilbert wrote:
> >  > Also is it possible that a lab may keep the same code despite
> >  > at a later date it changes coding systems?
> > Sure. Perhaps not very likely, though. So we'd probably need
> > the constraint unique(fk_test_org, code, coding_system) right ?

And/or on the additional chance that a numeric code, which was used 
under an old coding system for one test, happens to be used in a new 
coding system  for a different test, we now have the constraint 
unique(fk_test_org, code, coding_system) in place of 
unique(fk_test_org, code), right?