Geek Answers Handbook

Grouping tables in a MySQL database

Here is my reflection: I have ER charts representing several thousand tables in a database. Entities represented in each of several files have some associative relations, as determined by the developer. Although relationships exist between objects in other files, they are not displayed. This seems like a common practice for charting databases of this size.

I entertained the idea of ​​representing these groupings in a MySQL database. Since SCHEMA is an alias of DATABASE in MySQL, I cannot find a mechanism for grouping tables in a database.

I am wondering if someone else has developed a creative team concept that they would like to share with me. Or, even better, if MySQL supports some mechanism for grouping tables in a database, please let me know. (I apparently missed this in my research)

+5
source share
2 answers

You can use the same prefix for the tables you want to use, for example, you have groups of employees that you create for the emp_main and emp_Children and emp_tasks tables, then you can have another group, for example, the items you sell that run everything with her _

+10
source

, Schemas Postresql , MySQL , . , MySQL Workbench, EER : https://dev.mysql.com/doc/workbench/en/wb-using-layer-tool.html

0

More articles:


All Articles