什么是查找表？ [英] What is a lookup table?
问题描述
我刚刚给了一个数据库图表，我创建了一个数据库，我创建了我们的头数据库的人，她把一堆注释，建议我重命名某些表，所以它是清楚的，他们是查找表（添加lu到开始的表名）。
I just gave a database diagram for a DB I created to our head database person and she put a bunch of notes on it suggesting that I rename certain tables so it is clear they are lookup tables (add "lu" to the beginning of the table name).
我的问题是，这些不符合我认为是一个查找表的定义。我一直认为一个查找表基本上是一组没有定义任何关系的选项。示例：
My problem is that these don't fit the definition of what I consider a look up table to be. I have always considered a look up table to basically be a set of options that don't define any relationships. Example:
luCarMake
-----------
id Make
-- ---------
1 Audi
2 Chevy
3 Ford
我的工作中的数据库人建议我重命名几个表，这些表只是将一个表映射到另一个表作为查找表。示例（下面的Location_QuadMap）：
The database person at my work is suggesting that I rename several tables that are just IDs maping one table to another as lookup tables. Example (Location_QuadMap below):
Location
----------
LocationId
name
description
Location_QuadMap <-- suggesting i rename this to luLocationQuad
----------------
QuadMapId
LocationId
luQuadMap
---------
QuadMapId
QuadMapName
是否可以假定她错读了图表，还是有另一个我不知道的定义？
Is it safe to assume that she misread the diagram or is there another definition that I am not aware of?
推荐答案
您有什么称为联结表格。也称为：
What you have there is called a junction table. It is also known as:
- 交叉参考表
- 桥接表
- 加入表
- 映射表
- 交集表
- >
- 链接表
- cross-reference table
- bridge table
- join table
- map table
- intersection table
- linking table
- link table
但我从来没有看到用于此目的的查找表
But I've never seen the term "lookup table" used for this purpose.
这篇关于什么是查找表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
