Communities::Database -> Schematic

A database schematic is a visual represenation of how the database is arranged. For example, the WordPress database schematic can be seen to focus mostly on posts and users, with supporting tables for post metadata and user metadata, as well a taxonomy which is used to organize posts. This makes it compact and easy to work with. However, for more complex needs another database structure may be more suitable.

In contrast, the database structure for concrete5, which is built upon a content management framework called Symfony, has a much more complex database structure consisting of 250 tables (in contrast to the 12 default tables that WordPress uses). Though this might seem more daunting for the average user, this should provide much finer grained control for the information it stores and how it is used.

Below is the database schematic for WordPress:

Click on image for better resolution.