java Why does the Mybatis system add table prefixes when designing tables? Are there any disadvantages in not adding them?
Thanks
PHP中文网2017-06-12 09:23:42
Obviously to distinguish projects. When there are many database tables, table prefixes can be used to achieve faster search, maintenance, etc.
给我你的怀抱2017-06-12 09:23:42
This is really a poor design. Different databases should be used to distinguish projects!
给我你的怀抱2017-06-12 09:23:42
This is a habit developed by old programmers for future generations haha
PHP中文网2017-06-12 09:23:42
Generally related to business logic.
For example, system-related tables sys_user, sys_role, etc.
Query related tables query_money, query_time, etc.