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
_______________________________________________
Gnumed-devel mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/gnumed-devel
