Posts are mostly stored across two table in the db wp_posts and wp_postmeta but their is related content in wp_comments, wp_term_relationships etc… + a single WP post can have multiple entries per post in the posts tables as its how wp supports revisions.
see
http://codex.wordpress.org/Database_Description
Hacking into the db is probably a bad idea. If you want people to contribute to your content you’d be better off looking at letting them do it thought the wordpress ui and using the build in user roles.
Or install a wiki like Media Wiki. like the way wp.org use it for codex.wordpress.org
Finally if you really do want to press on building your own ui I’d use the json, or xmlrc api wordpress provides and used for thinks like the ios app, it would be a lot safer than poking the db especially if your not already familiar how WP’s db structure and how WP uses it.
http://jetpack.me/support/json-api/
http://developer.wordpress.com/docs/api/
http://codex.wordpress.org/XML-RPC_WordPress_API
Hi geraintp
Many thanks for your help and sound advise. It is greatly appreciated
P
