I was looking at how Elgg stored data and it made start wondering.
Usually when your site has posts, comments, etc you would have tables something like (posts, comments), but everything here is stored in two tables.
The two tables are: `entities` and `metadata` and they are structured as so:
Entities:
```
------------------------------------------------------------
| Name | Type |
------------------------------------------------------------
| guid | int(20) |
| type | enum('object',...
Database architecture
from MySQL https://ift.tt/3d8yDyA
via IFTTT

0 Comments