Re: [Gnumed-devel] Should patients have a "status" ?

[Karsten Hilbert]

On Mon, Jul 04, 2011 at 01:01:45PM -0700, Jim Busser wrote:

> >> so… you are open to this in GNUmed future?
> > 
> > I think you've got good arguments in favor of it :-)
> 
> As a single column
> 
>       dem.identity.status_in_praxis
> 
> or normalized into
> 
>       dem.identity.status

Since there can only be one status per identity it can
technically be a column of dem.identity directly.

The grander plan might be that being active or not is a
property of the *patient* rather than the person and thus it
might be more appropriate for it to live in a future

create clin.patient (
        pk serial primary key,
        fk_identity integer foreign key
                references dem.identity(pk)
);

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346