looking for a complete documentation for Drupal's database schema - need to have some overview
Check Drupal's Schema API. Here is the link to it. Also the Book "Pro Drupal Development" has an excellent chapter on Working with Databases.You might find that one useful too.