how to manually add a node in drupal 7 in the database I have managed to display the title but im missing the body of the title. i cant find in the database which table i missed to edit.

here's the list of tables i editted:


node
node_revision
node_comment_statistics
taxonomy_index


for the body i assume that these fields are responsible for it:


field_data_body
field_revision_body
field_data_taxonomy_forums
field_revision_taxonomy_forums


The node i made has no comments so no comment table is editted.

Am i missing other tables to edit here? 

SO i assume i have editted all the necessary tables but i seemed to have missed something here cause ONLY THE BODY IS MISSING.
Because you are trying to understand Drupal database concept, you are checking every insert you made in the Drupal admin section, and by doing so Drupal is caching your data.    

So you are not missing anything. You only need to clear Drupal cache, try to truncate each cache table one by one.