tap_schema.keys
Description
The table of foreign key relations between tables
Columns
An asterisk (*) marks an indexed column.
| Name | Type | UCD | Unit | Description | |
|---|---|---|---|---|---|
| key_id | char |
Unique identifier of the foreign key relationship; used to join with the key_columns table |
|||
| from_table | char |
Fully qualified name of the table containing the foreign key (i.e. schema.table) |
|||
| target_table | char |
Fully qualified name of the referenced (target) table |
|||
| description | char |
Description of the relationship |
|||
| utype | char |
Optional data model identifier for the relationship |