Contains a row for each column, or set of columns, that comprise a foreign key.
|
Column name
|
Data type
|
Description
|
|---|
|
constraint_object_id
|
int
|
ID of the FOREIGN KEY constraint
|
|
constraint_column_id
|
int
|
ID of the column, or set of columns, that comprise the FOREIGN KEY (1..n where n=number of columns)
|
|
parent_object_id
|
int
|
ID of the parent of the constraint, which is the referencing object.
|
|
parent_column_id
|
int
|
ID of the parent column, which is the referencing column.
|
|
referenced_object_id
|
int
|
ID of the referenced object, which has the candidate key.
|
|
referenced_column_id
|
int
|
ID of the referenced column (candidate key column).
|

See Also