Re: [Gnumed-devel] Test results schema question re method of acquiring the result

[Karsten Hilbert]

> > > Among the auditing fields is modified_by which is NOT NULL DEFAULT
> >> 'current_user' but what value is written in here when the row is
> >> created as part of an import?
> >Well, the "current_user". The database does neither know nor
> >care whether that's a human or a script.
> 
> Ah - so perhaps instead of having to create an "organization", the 
> original source could be preserved, and this value for "current_user" 
> would identify either the individual (if it happened to be a person 
> making a manual entry)  or a script because are scripts are ??? 
> credentialed in order to have a status as a user, in order to be able 
> to have permission to import rows?
Well, *any*thing/one needs to get a credentialled connection
to the database no matter whether it's a script or a user. The
account part of those credentials gets written to the
modified_by field of the auditing structure - note that we
even enforce this by means of a trigger...

You'd still have to create an organization to record where the
results where generated - not who *entered*/changed the
results in your database. However, if you don't care you can
get away with a generic "a lab" organization to which you just
link *any* data.

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