Relational Database Modeling - (Xref|Cross-reference|Lookup) table

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Relational Table - Data Modeling

Table of Contents

1 - About

A lookup table is also known as:

  • XREF
  • or cross-reference table

A lookup is when a query joins the base table and the lookup table to obtain the values of the lookup table for each row in the base table.