Wiki Spaces
Documentation
Projects
Resources
Get Help from Others
Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack
We really need to be able to constrain certain UI elements to just a single type of location, rather than all the locations in the world. I propose the following
create table location_type (
location_type_id integer primary key,
name varchar not null,
description varchar not null
);
alter table location add column (location_type integer references location_type)
An alternative would be to allow 0:n tags per location, which would be more powerful:
create table location_tag (
location_tag_id integer primary key,
location_id integer references location,
tag varchar not null
);
--Djazayeri 10:55, 13 September 2007 (EDT)