I'm trying to create a link between registered users of my website and my personnel files. I've created an Extended Users page in Couch to add a bunch of user info, now I want to read the Couch database to relate it to my other app. I can get the basic data from the couch_users table, but how can I find the related fields from the extended users?
The extended-users, as you know, creates normal cloned pages for each user. So, all the extended data gets stored exactly like for the other templates of your site.
Couch uses EAV (Entity Attribute Value) format for storing data so you won't find that data packaged in discrete 'one table per template' as you might expect. Rather, the data for all the templates goes into just two tables - 'couch_data_text' and 'couch_data_numeric' (with a third table 'couch_fulltext' storing data used by cms:search tag).
I think it'd much easier for you to use cms:pages to query back all data as formulating a custom query for EAV can be pretty daunting.