[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
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