Dnn Database Core table structure and design ideas

1. Table Name:
Tab page table, tabmodules page module table, modules module table, moduledefinitions module definition table, modulecontrols module control table, and desktopmodules desktop Module

2. tab is a self-join table, that is, page in dnn)

3. modules is the module unit of dnn content management. It is the so-called module in the following section. We will call it here.Page Module. The relationship between tabs and tabs is many-to-many, that is, multiple instances of the same module can be put on a page (function: Add a new module ), the same module instance can also be placed on different pages (function: add existing modules) (Note: adding modules here is actually adding a desktop module. A desktop module may have several page modules, ).

4. toptopmodules desktop module. modules in the eyes of module developers, such as blogs, news, and downloads, are the modules we usually install and uninstall. Here we callDesktop Module.

5. desktop and page modules. We usually seem to get used to calling them modules. But in fact they are not the same thing at all, which is quite different. From the relationship diagram, we can find that a toptopmodules desktop module can have several (module-defined moduledefinitions) and one (module-defined moduledefinitions) can have several page modules, such as HTML, link is too simple. Therefore, a desktop module has only one module. When we add a desktop module to a page, only one page module is added. However, when we add a blog module, we will find that when we add a desktop module, there will be several more page modules on the desktop at once. This is because the blog is too complicated and the definition of a module is not fixed, therefore, several module definitions are added to a desktop module. When a desktop module is added to a desktop module, all the module definitions of this desktop module are added once (one module definition, A page module on the page ). The modulecontrols module control table can also be called a control table, that is, the items in the control column below are basically a control table that corresponds to a user control, so I call it the module control table.