Re: [Gnumed-devel] basic test types

[Karsten Hilbert]

> > > > > >Note that GnuMed also makes it possible to aggregate various
> >> >> >types of BP measurements under a single test type - or several
> >> >> >aggregate test super types even with overlapping contributing
> >> >> >types... So one might define "all BP", "in-house BP",
> > > >> >"right-arm in-house BP", "external BP" etc etc.
> >...in table test_type_local, the local_code and local_name
> >[are now] defined to be unique,
> 
> Well, if test_type.code and test_type_local.local_code are now each 
> unique and therefore a one-to-one relationship, how is aggregation 
> done?
No, the constraints are

unique(local_code, local_name)
unique(fk_test_type, local_code)

eg:
a) each local_code can only ever be associated with one local_name
   (eg. long-short name combinations are unique)
b) each test_type can only once be associated with a
   given local_code (and thus local_name)

Does that make sense ?

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346