Multisite network is a feature that allows creation of multiple sites within the same WordPress installation, while sharing the available resources. Developers moving to WordPress from pure PHP development may be unfamiliar with this concept. The whole database structure changes in multisite in a way that we can't anticipate. So, it's important to get an idea of how multisite database works in case you are planning to develop multisite compatible plugins and themes. The following is a simple illustration of the changes in multisite compared to single site installations:
As you can see, six new tables have been added to the database and the existing tables have increased. This image only illustrates how tables are connected in multisite environment. However, this not a precise relationship diagram between the tables. Let...