GLOBAL MAP DATA DICTIONARY #1.5219 -- SQLI_FOREIGN_KEY FILE 9/29/25 PAGE 1
STORED IN ^DMSQ("F", *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 22.2)
-----------------------------------------------------------------------------------------------------------------------------------
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.
CROSS
REFERENCED BY: F_TBL_ELEMENT(B)
^DMSQ("F",D0,0)= (#.01) F_TBL_ELEMENT [1P:1.5216] ^ (#1) F_PK_ELEMENT [2P:1.5218] ^ (#2) F_CLM_ELEMENT [3P:1.5217] ^
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):