需要数据库术语帮助
如果一个表中的数据本应位于另一表中，那么它们之间的关系是什么？
If you have data in one table that should be in another table, what is their relationship called?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
这种关系被称为健康但功能失调。
如果您想知道它的“术语”：
去标准化。
我说它是“健康的”，因为有时开发人员希望性能胜过理智。 但就像任何关系一样，尽量不要让它成为常态。
编辑：是的，我在那里说了一个关于关系的双关语。 今天是星期五，我感觉很兴奋。
The relationship is called Healthy, yet dysfunctional.
If you want to know the 'term' for it:
De-Normalized.
I say it's 'healthy' because there are times that developers want performance over sanity. But just like any relationship, try not to make it the norm.
Edit: Yes, I stuck a double entendre about relationships in there. It's Friday, I'm feeling frisky.
我认为OP可能含糊其辞地表达了他的问题，并且实际上是想问：“一个表中的条目引用另一个表中的行的关系如何称呼？” 这是一个外键约束。
I think the OP may have worded his question ambiguously and is really trying to ask, "What do you call the relationship in which an entry in one table references a row in another table?" That is a foreign key constraint.
未标准化的垃圾？
非规范化是从未规范化的数据库
非规范化是曾经规范化过的数据库，但有人出于某种原因（可能是性能）决定对某些数据进行洗牌
Unnormalized Junk?
Unnormalized is a database that has never been normalized
Denormalized is a database that has been normalized at one time but someone has decided to shuffle some data around for a reason (could be performance)