sysfkcol system table

Each row in the sysfkcol system table describes a foreign key column.

Column name Column type Description
table_id UNSIGNED INTEGER A unique identifier for the table to which the foreign key applies.
foreign_key_id UNSIGNED INTEGER A unique identifier for the foreign key that this column belongs to.
item_no UNSIGNED SHORT The order of the column in the foreign key.
column_id UNSIGNED SHORT A unique identifier of the table column that refers to the foreign column.
foreign_column_id UNSIGNED SHORT A unique identifier of the table column that is being referred to.
 Constraints