15.00 - Definition of a Referenced (Parent) Table - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Definition of a Referenced (Parent) Table

A child must have a parent, and the referenced table in a PK-FK relationship is referred to as the Parent table. The key columns in the Parent table that see a Child table are called referenced columns.

Since the referenced columns are defined as unique constraints, the referenced column set must be one of the following:

  • A unique primary index (UPI), not null
  • A unique secondary index (USI), not null