Relation Modeling - (Xref|Cross-reference|Lookup) table

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > RDBMS (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.

data/type/relation/modeling/lookup.txt · Last modified: 2017/09/13 16:15 by gerardnico