Forum OpenACS Development: Response to groups and group_types massively messed up.

Collapse
Posted by Stephen . on
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?