Re: [Gnumed-devel] The 1,2,3's of SOAP for multiple problems-2

[Karsten Hilbert]

> >> am not sure how we expect to draw out stored info on risk behaviours
> >> (EtOH, tobacco, sex & other so-called Social History), likewise
> >> Family History if these are all supposed to be entered into
> >> clin_narrative
> >Again, you can attach any number of arbitrarily created tags
> >to any clin_narrative item. It may indeed be useful to
> >pre-create a number of "well-established" tags.
> 
> Is there already support in the schema to hold such tags?
Sure, that's what I'm saying all along ! Look at
clin_item_type, lnk_type2item, v_pat_item_types and
v_types4item.

> I can see 
> in clin_narrative only the soap_cat column which is reserved for 
> "s|o|a|p", no?
If we used columns in clin_narrative to store the code we
would either need arbitrary numbers of columns or use an
interpreted column which creates more trouble than it's worth
particularly since we are very likely to want to select by
given tags.

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