demographics (was: Re: [Gnumed-devel] gnumed ideas 0.1 and post-0.1)

[J Busser]

At 6:44 PM +1100 2/21/05, Ian Haywood wrote:

> This is long-winded way of saying we do
> need to hardwire some database numbers in the business
> layer, so we can say, "this is an e-mail", "this is a
> fax" etc, no matter what its actually called in the
> local language.. For ID numbers it doesn't matter
> (because code that uses them will be locale-specific
> anyway)

the sql file gmDemographics-GIS-data.sql contains

insert into enum_comm_types (id, description) values (1, i18n('email'));
insert into enum_comm_types (id, description) values (2, i18n('fax'));
insert into enum_comm_types (id, description) values (3, i18n('homephone'));
insert into enum_comm_types (id, description) values (4, i18n('workphone'));
insert into enum_comm_types (id, description) values (5, i18n('mobile'));
insert into enum_comm_types (id, description) values (6, i18n('web'));
insert into enum_comm_types (id, description) values (7, i18n('jabber'));

PS I also noted in the PG autodoc html tables many of the lnk_identity and lnk_org tables have fields id* that should be pk* or fk*, should those too be changed? karsten?