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