Re: [Gnumed-devel] re: concrete example

[Karsten Hilbert]

> for clinician measured and recorded data, are applications going to use 
>  3 |     -3 |                |                | your own practice  ,
> or an application instance test_org ?

IMO "your own practice" or a locally defined variant thereof.
Certainly not application instance.

> >     'dBP',
> >     'diastolic blood pressure',
> >     'right arm, sitting, standard size cuff assumed',
> >     'Pa'
> >);
> >
> >insert into test_type_local (code, name)
> >values (
> >     'RR',
> >     'diastolic blood pressure'
make the "blood pressure", not "diastolic blood pressure"

> >insert into lnk_ttype2local_type (fk_test_type, fk_test_type_local)
> >values (
> >     currval('test_type_pk_seq'),
> >     currval('test_type_local_pk_seq')
> >);
> >
> so code 'RR' is a key to the basic test type, and all test_type that 
> need to be converted
> are connected via lnk_ttype2local_type , and local_type will point with 
> attribute code to
> the  basic test_type ?
yes, IF one wants to aggregate blood pressure values of
different names under one name

however dBP and sBP are not very good examples for this
because they actually represent one *composite* values, not
two readings of the same test type

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