15.00 - Domains and Keys - Teradata Database

Teradata Database Design

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

Domains and Keys

The following diagram indicates the relationship among primary and foreign keys drawn from the same domain.

The following rules apply to these relationships.

  • All primary key values for a table are drawn from the domain that defines all possible values for that column.
  • That domain cannot be defined with an XML, BLOB, or CLOB data type.

  • All foreign key values that reference a primary key value in another table are drawn from the same domain as the values for that primary key.
  • That domain cannot be defined with an XML, BLOB, or CLOB data type.