Dear Brian,
many thanks for the time invested and the fixes. Some of these can be probably included in the forthcoming release, some of these might require more changes. On some of the changes, you provided a fixed version for the create-scripts, but it is not clear, how to deal with these in upgrades. However since we have this nicely in the tracker, we can improve stepwise.
Concerning the rel-types: you are referring probably to these changes:
https://openacs.org/forums/message-view?message_id=5330734
https://openacs.org/forums/message-view?message_id=4031049
by these postings, the documentation and intentions should be clear. The PostgreSQL version appears to work nicely.
Good job and many thanks!
-g