acs_objects.object_type
is indexed, and I think it's fine to join against the
acs_objects
table. If we're not allowed to touch it then what's the point?
comment on table group_type_rels is '
Stores the default relationship types available for use by groups of
a given type. We May want to generalize this table to object_types and
put it in the relationships sql file, though there is no need to do so
right now.
';
Maybe this got half finnished?
It seems to me that group_type should be an object referencing the
acs_objects table with object_type = group_type, and the groups table
should have a column for group_type_id, referencing this table.
Why?