java - When dealing with data relationships, what are the advantages and disadvantages of using database table foreign keys versus in-code maintenance?-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

java - When dealing with data relationships, what are the advantages and disadvantages of using database table foreign keys versus in-code maintenance?

曾经蜡笔没有小新 2017-05-17 10:08:48

463

Recently I was designing a library table for an enterprise application project, and I encountered some data association problems. I was undecided whether it would be better to maintain within the code or make external associations. I am seeking the opinions of experts.

曾经蜡笔没有小新

reply all (2)

巴扎黑2017-05-17 10:10:48 2 floor

Let me tell you my personal opinion.
Normally, it is recommended to use database foreign keys. This has relatively complete constraints. Moreover, most applications (80%) of most companies have not yet reached the level of database segmentation. So why not just rely on the integrity of the database? ?

Not using foreign keys is usually too large, so the number should be more than a million. Need to be segmented. Only manually use the program maintenance. . .