Files > SQLI_FOREIGN_KEY

name

SQLI_FOREIGN_KEY

number

1.5219

location

^DMSQ("F",

description

A set of columns in a table that match the primary key of another table. They represent an explicit join of the two tables. Each foreign key element points to it's table element (SQLI_TABLE_ELEMENT), a column in the local table (SQLI_COLUMN) and a primary key element of a foreign table (SQLI_PRIMARY_KEY). The primary key table element of the foreign table has the domain of that table, which makes the connection.

Fields

#	Name	Location	Type	Details	Index	Description
.01	f tbl element(+)	0;1	POINTER	1.5216	B	IEN of foreign key table element in SQLI_TABLE_ELEMENT
1	f pk element(+)	0;2	POINTER	1.5218		IEN of primary key element in SQLI_PRIMARY_KEY of foreign table
2	f clm element(+)	0;3	POINTER	1.5217		IEN of column of this table in SQLI_COLUMN which matches foreign PK