[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] Re: Dump of the Contacts stuff
From: |
Ian Haywood |
Subject: |
[Gnumed-devel] Re: Dump of the Contacts stuff |
Date: |
Sat, 13 Mar 2004 10:49:52 +1100 |
On Fri, 12 Mar 2004 19:02:54 +1100
Richard Terry <address@hidden> wrote:
ID_Category:
> Say you want to write a referral letter, and don't know the names of all the
> paediatic oncologists in your town. in the Category section of the edit area,
> you type Pae.... the system runs of and up pops a list of names - eg
OK, sounds good. But then what is ID_Occupation for?
> going home, data_communications held all communications records and is linked
> to the links table. People in the links table can be either alone (no
> organisation), or employees of the organisation. If so the record will
> contain the person_id, organisation_id, organisation_commuication_ID and a
> another communication_ID for the person( because they may have a different
> work extension etc, but one still may want to record their mobile phone, home
> phone etc). In practice this schema works very well.
So there *isn't* a communication record for organisations as a whole?
Ian
--
PGP public key E750652E at wwwkeys.pgp.net
9BF0 67B7 F84F F7EE 0C42 C063 28FC BC52 E750 652E
pgpp7EFlF9YR7.pgp
Description: PGP signature
- Re: [Gnumed-devel] demographics.sql, (continued)
Re: [Gnumed-devel] demographics.sql, Jim Busser, 2004/03/08
Re: [Gnumed-devel] demographics.sql, Ian Haywood, 2004/03/10