Forum OpenACS Development: Re: Augmenting acs_objects - adding package_id, name, and clarifying other fields

How would a generic object map work? If you want to relate two objects, stick them in this table with a tag on the relationship. You can use the same idea for a package_id, or subsite_id, allowing objects to be associated with zero or more packages or subsites.

create table object_map (
 object_id_1,
 object_id_2,
 tag
);

select * from object_map where tag = 'site image';

select * from object_map where object_id_1 = :my_site_node
and tag = 'site image';

select * from object_map where object_id_2 = :my_image
and tag = 'site image';