The content repository doesn't define any meaning to the parent_id relationship. The meaning is defined by the applications that use the content repository.
There isn't any restriction or problem to having a content_revision as a parent_id, although it could be confusing if the semantics were not documented in the package that used the content repository in that way.
