I see a need to make content management more "Joomla" like and Joomla has the concept of Section and Category for attributing content. The Section would correspond to the existing ContentAssoc.mapKey and Category would be modeled by ContentPurpose/Type.
The problem (and it is a minor one) is that there will be times that you would like to present the "app-specific" categories (ContentPurposeTypes) to a user without including all the seed types and it probably would not be desirable to get rid of the seed ContentPurposeTypes. It seems like adding a "parentTypeId" to ContentPurposeType would not break anything and it would be easy to select just the app-specific types. Thoughts? -Al