I wonder if there is a name for such a mapping table in RDBMS-land...?

We call them lookup or mapping tables.