Sybase Adaptive Server Anywhere - SYSFKCOL System Table

SYSFKCOL system table
1010
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.