Initially I'd go with ContentRequest -> ContentTweets -> ContentNode -> ContentNodeRevision
:
ContentNode ContentNodeRevision
/ /
ContentRequest --> ContentTweets --- ContentNode --- ContentNodeRevision