[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] reviewed status tables/views

From: Ian Haywood
Subject: Re: [Gnumed-devel] reviewed status tables/views
Date: Wed, 26 Oct 2005 09:23:57 +1000
User-agent: Debian Thunderbird 1.0.7 (X11/20051017)

Karsten Hilbert wrote:
> Attached is a first cut at "reviewed" objects.
> Karsten

> -- ---------------------------------------------
> create table reviewed_status (
>       pk serial primary key,
>       table_oid oid
>               not null,

This is an interesting idea, however to write an Inbox widget sanely we
need to have a defined list of which tables are reviewable.
(presumably lab_result and doc_obj, in the first instance)
and then a view using SELECT ...UNION SELECT to provide a single view of 
unreviewed objects.

>       fk_reviewed_pk integer
>               not null,
>       fk_reviewer integer
>               not null
>               references public.xlnk_identity(xfk_identity),
>       is_technically_abnormal boolean
>               not null,
>       clinically_relevant boolean
>               not null,
> ) inherits (audit_fields);
I was looking for a timestamp field, but I realise we inherit modified_when 

Most importantly, we need to find clinical items 'destined' for a particular 
but not actually seen yet, a third flag
        seen boolean,

obviously if false then is_technically_abnormal and clinically_relevant are 
false too.

        comment text,
would be useful too,


reply via email to

[Prev in Thread] Current Thread [Next in Thread]