Which table provides the block and areas relationship? From my observation it is "collectionversionblocks" table that stores page id (cID), block id (bID) and area name (arHandle).

This table then has relation with "btcontentlocal" table that stores the data that goes into the particular block.

Is this correct? I am trying to add some data directly into the database from another system. Some of them are showing up correctly in the pages within the areas but some of them are not being displayed.