ASA SQL Reference
System Tables
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.