I’ll update this answer periodically over time as I lean more about the platform. This link speaks directly to what I’ve mentioned above:
The WordPress Database Structure
Edit (pretty much answers everything else):
https://cadent.com/use-git-to-develop-a-wordpress-site-with-a-team-of-coders/