Forum OpenACS Development: Attribute "tag" in party_approved_member_map
It seems to me as we should drop this attribute, since party_approved_member_map reaches on some of our installations several mio entries, and the "tag" field contains sometimes garbage (deleted membership rels, since it has no fk).
However, the following should be done to reduce the guesswork:
a) rename "tag" into "originating_rel_id"
b) replace the "0" of the sellf-membership by a NULL
c) define a fk for "originating_rel_id" to acs_rels.
These changes are now committed to the oacs-5-9 branch.
The Oracle version us quite different, it uses a ref-count instead of the "originating_rel_id", where the latter makes it easier to understand the whereabouts of the values and eases deletions, etc.