Re: [Gnumed-devel] Vaccine table questions

[Karsten Hilbert]

On Mon, Sep 12, 2011 at 07:47:01AM -0700, Jim Busser wrote:

> Part of my reason for asking is because the Canadian drug
> database includes 68 branded drugs having ATC = "J07foo".
> 
> From these, I can create 72 vaccine records (68 + 4
> because, in 4 cases, a single branded vaccine is available
> in 2 routes, intramuscular AND subcutaneous).

Then, technically, it's 4 products rather than 2.

Companies deciding they want to give the very same name
(brand) to two of their products does not mean we have to
follow that braindead route.

> Questions:
> 
> 1) Is it ok for two different clin.vaccine records to be
> keyed to the same unique branded_drug?

Technically it currently is, yes, but I'll remove that by
UNIQUEing the fk_brand in clin.vaccine. Thanks for finding
that hole.

> 2) Will the schema (based on discussion above) allow them
> to be imported with is_live is NULL?

I know you already cringe because you suspect you already
know the answer.

> The information is not contained in the source file and
> there is no easy way for me other than to look up the
> product monograph for every product.

Have it done by a medical student ?

> If we should wish to have a safety constraint, it should
> be that the vaccine not be allowed to be "administered"
> while is_live is NULL so whichever clinician first
> "administers" it would have to first "initialize" this
> value.

That is too high-level to be useful.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346