2007-09-13 Developers Conference Call

Location Types

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)