Contents Index SYSFILE system table SYSFOREIGNKEY system table

ASA SQL Reference
  System Tables

SYSFKCOL system table


Column name Column type Column constraint Table constraints
foreign_table_id UNSIGNED INT NOT NULL Primary key. Foreign key references SYSCOLUMN.table_id. Foreign key references SYSFOREIGNKEY
foreign_key_id SMALLINT NOT NULL Primary key, foreign key references SYSFOREIGNKEY. foregin_key_id
foreign_column_id UNSIGNED INT NOT NULL Primary key, Foreign key references SYSCOLUMN column_id
primary_column_id UNSIGNED INT NOT NULL

Each row of SYSFKCOL describes the association between a foreign column in the foreign table of a relationship and the primary column in the primary table.

foreign_table_id    The table number of the foreign table.

foreign_key_id    The key number of the FOREIGN KEY for the foreign table. Together, foreign_table_id and foreign_key_id uniquely identify one row in SYSFOREIGNKEY. The table number for the primary table can be obtained from that row (using the SYSFOREIGNKEY table).

foreign_column_id    This column number and the foreign_table_id identify the foreign column description in SYSCOLUMN.

primary_column_id    This column number and the primary_table_id obtained from SYSFOREIGNKEY identify the primary column description in SYSCOLUMN.


Contents Index SYSFILE system table SYSFOREIGNKEY system table