At a high level for each Ci in the list of those attached to a change there will be an entry in regular table holding the attributes without versions. The name of the table will be usr_xxx where xxx is the name attribute of the business object. You'll then also find a table with a similar name holding the version-able data. You will also need to add in any attributes from the Configuration Item table as that is the parent for all those sorts of tables.
if you want to see how ERDs can be produced, take a look at this article.