The following table defines the Referential Integrity terminology that CheckTable uses.
|Primary Key||One or more columns that uniquely identify a table row.|
|Foreign Key||One or more columns in a table (the child table) that references the Primary Key in one or more tables (the parent tables).|
|Parent Table||Table having a Primary Key that is referenced by another table, the child table.|
|Child Table||Table having a Foreign Key that references the Primary Key in another table, the parent table.|
For more information on referential integrity, see Teradata Vantage™ - SQL Fundamentals, B035-1141 and Teradata Vantage™ - Database Design, B035-1094.