开发者

How do you call a table that contains static id-value, for reference by other tables?

开发者 https://www.devze.com 2023-03-20 17:28 出处:网络
How do you call a table that just contains a static list of ids and static values, whose purpose is to be referenced by other tables?

How do you call a table that just contains a static list of ids and static values, whose purpose is to be referenced by other tables?

For instance, a countries table like开发者_Go百科 1:Fiji,2:Cuba.3:Peru,.... Then a users table contains for each user the id of the country they were born in.

How would you call the countries table? I used to know it as a "master table", but most Google results use it with other meanings. Is there a better word?


"Lookup Table" is probably what you are after here.


You call it a table.

I glanced through the indexes in all my books on relational databases. Not a single one had an entry like "lookup table", "master table", or "junction table". There's a reason.

0

精彩评论

暂无评论...
验证码 换一张
取 消