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

[Ian Haywood]

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 
here.

Most importantly, we need to find clinical items 'destined' for a particular 
individual,
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,

Ian