Re:[Gnumed-devel] q about schema

[Syan Tan]

What is the preferred way of blob import ? 
 - I noticed that blob.med_doc looks obligatory, and that there needs to be a
reference
to blob type as well , and also a link to a patient ( ? also not null) and 
reviewer.
 - the import type I  was thinking of has a specialist table , with name,
address, and specialty _type ,  where specialty_type is sometimes duplicated due
to mispelling or different phrase
(e.g. general physician/physician/general medicine ). 
 - I was thinking of using the specialty table to proliferate the doc_types, so
then the
docs can be imported , since this should be an automated step, perhaps an 
ability
to merge
doctypes via gnumed application could be done later ; 
otherwise, can the med_docs have optional doc_type , or an unassigned doc_type?

Also , the import source has 2+1 tables for medication and scripts. There is a
drug_no field
that is supposed to uniquely identify the medication, but there is
denormalization here as
well , so that when the medication is printed, it's name and presentation is
stored in
2 text fields in the script table. It is possible to use group by on these
fields, to yield
a drug_no , drug_name, presentation table, but it looks like at some stage 2
spaces were introduced as separators to some drug names, so a drug_no may
reference at least 2 different
drug names with different spacing. I suppose I'm asking where to store 
medication
and scripts
and whether an external drug schema can be used , and how to do this . There is
no ATC code
in these drug tables. Any suggested even preliminary adhoc method accepted 
welcome.

Another type is the letter type, which raises the question of RTF readers / and
or writers.
Is there a way of storing the type of letter document with gnumed , and have 
some
sort
of mimetype/x-application etc... where say Abiword is fired up ? 
this might lead to a problem with templates though , as I gather the default 
template type for gnumed was to be postscript .
A more basic step is , how to store letters against patients, and any special
requirements
(e.g. mandatory linking to a specialist provider ? )