What is a lookup table?

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.