What would the best German word be for an SQL table whose only purpose is to match e.g. an id with a name? In English, I would call this a "lookup table" since the ID is "looked up" and the corresponding name is returned.
My best guess would be Nachschlagtabelle? Is that the standard term?
table
? Don't you use all tables to lookup something?