gnumed-devel
[Top][All Lists]
Advanced

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

Re: [Gnumed-devel] install on Fedora


From: Ian Haywood
Subject: Re: [Gnumed-devel] install on Fedora
Date: Sat, 13 Mar 2004 21:29:31 +1100

Hmm... looks like the list is back. 
The last message had a round trip of around 4 minutes.

On Thu, 11 Mar 2004 19:54:11 +0000
Karsten Hilbert <address@hidden> wrote:
> GnuMed should run fine with Python 2.2/2.3. It doesn't work
> with 2.1 anymore since Ian started using the dict() construct
> recently.
Sorry, that was not intentional. I know debian stable still uses python 2.1, 
but we need to
use testing anyway for something else, I've forgotten what. So basically I'm 
saying: do we need 
python 2.1 support? If so, I'll change it.


I have added this table, but not commited,  to gmDemographics.sql, please 
comment
-- ==========================================================
-- the table formerly known as lnk_person2address
-- homologous to data_links in Richard's schema
create table lnk_person_org_address (
        id serial primary key,
        id_identity integer references identity,
        id_address integer references address,
        id_type int references address_type default 1,
        address_source varchar(30),
        id_org integer references org (id),
        id_occupation references occupation (id), -- the job they do at this 
organisation
        unique(id_identity, id_address)
);

Taking the main concept from Richard's contacts database, a three-way
linktable that binds individuals to organisations at a particular address.

Although it is a limited retreat from the normal form, I think it is the best 
solution, using multiple
linktables is, if anything, more likely to lead to inconsistency.

Ian 

-- 
PGP public key E750652E at wwwkeys.pgp.net
9BF0 67B7 F84F F7EE 0C42  C063 28FC BC52 E750 652E

Attachment: pgpsXVRTAaAQI.pgp
Description: PGP signature


reply via email to

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