Not everyone who uses WordPress needs to understand the database that it’s built on. But if you have reached that point, or are just curious, this is a really good, high-level overview of the database structure and how/if you should interact with it. Not a bad thing to know for anyone. Kind of like understanding how internal combustion engines work even if you’re not a mechanic.
Beginner’s Guide to WordPress Database Management with phpMyAdmin.