I am a PHP/MySQL application developer, but I am relatively new to Drupal. Naturally I am inclined to looking under the hood (hee hee), and am wanting to know where does Drupal store data content--the kind of content such as paragraphs of copy on pages. I've noticed that in a few tables in the database, there exist data in the data type of BLOB (particularly in the "cache" tables). I am wondering whether these are the places where the paragraphs of content copy is stored. If not, then where does things like paragraphs of copy reside?
Thanks for the anticipated insights :)