[edit] the early draft diagram that was here had errors and is more likely to cause problems than anything else. I've deleted it. If you want to see it for some reason I can't fathom just ask. Refer to [the result of this discussion](https://sqlite.org/forum/forumpost/d403e589ea827530?t=h) instead.