There are following below link need to click to know Magento 2 All 500 & more Tables, where each Magento 2 Table Briefly Explanation has been explained
Magento 2 All Database Tables [500 & more Tables]
Which Magento 2.x database table store customer’s Email Data
Which Magento 2.x Database Table Store Customer Newsletter Data
Which Magento 2.x database table store customer’s shipping and billing address
How To Remove Sales Order Data & Customer Data in Magento 2
How To Remove / Delete Catalog Data or Categories / Products in Magento 2.x
Which Magento 2.x Database Tables Store Customer Rating
Which Magento 2.x Database Tables Store Customer Review
Which Magento 2.x Database Tables Store Customer Wishlist Products
Which Magento 2.x Database Table Store Patches
Which Magento 2.x Database Table Store Static Blocks & Its Details
Which Magento 2.x Database Table Store CMS Pages & Its Details
Which Magento 2.x Database Tables Having All URLs Storage
Which Magento 2.x Database Tables Store Sales Order Data
Which Magento 2.x Database Tables Store Sales Invoice Order Data
Which Magento 2.x Database Tables Store Sales Tax and Its related Data
Which Magento 2.x Database Tables Store Catalog Price Rules