简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Database - java design table prefix meaning
世界只因有你
世界只因有你 2017-06-12 09:21:42
0
4
700

java Why does the Mybatis system add table prefixes when designing tables? Are there any disadvantages in not adding them?

Thanks

世界只因有你
世界只因有你

reply all (4)
洪涛
洪涛2017-06-12 09:23:42 4 floor

Obviously to distinguish projects. When there are many database tables, table prefixes can be used to achieve faster search, maintenance, etc.

Like+0
Add Reply
    给我你的怀抱
    给我你的怀抱2017-06-12 09:23:42 3 floor

    This is really a poor design. Different databases should be used to distinguish projects!

    Like+0
    Add Reply
      给我你的怀抱
      给我你的怀抱2017-06-12 09:23:42 2 floor

      This is a habit developed by old programmers for future generations haha

      Like+0
      Add Reply
        Ty80
        Ty802017-06-12 09:23:42 1 floor

        Generally related to business logic.

        For example, system-related tables sys_user, sys_role, etc.
        Query related tables query_money, query_time, etc.

        Like+0
        Add Reply
          Popular Topics
          More>
          Popular Articles
          Popular Tutorials
          More>
          Related Tutorials
          Popular Recommendations
          Latest courses
          Latest Downloads
          More>
          Web Effects
          Website Source Code
          Website Materials
          Front End Template
          About us Disclaimer Sitemap
          php.cn：Public welfare online PHP training，Help PHP learners grow quickly！