STANDARD DATA DICTIONARY #1.5219 -- SQLI_FOREIGN_KEY FILE                                                         3/24/25    PAGE 1
STORED IN ^DMSQ("F",  *** NO DATA STORED YET ***   SITE: WWW.BMIRWIN.COM   UCI: VISTA,VISTA                       (VERSION 22.2)   

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
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.  


              DD ACCESS: ^
              WR ACCESS: ^
             DEL ACCESS: ^
           LAYGO ACCESS: ^

CROSS
REFERENCED BY: F_TBL_ELEMENT(B)



1.5219,.01    F_TBL_ELEMENT          0;1 POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216) (Required)

              Foreign Key   
              LAST EDITED:      AUG 28, 1996 
              DESCRIPTION:
                                IEN of foreign key table element in SQLI_TABLE_ELEMENT 

              WRITE AUTHORITY:  ^
              CROSS-REFERENCE:  1.5219^B 
                                1)= S ^DMSQ("F","B",$E(X,1,30),DA)=""
                                2)= K ^DMSQ("F","B",$E(X,1,30),DA)


1.5219,1      F_PK_ELEMENT           0;2 POINTER TO SQLI_PRIMARY_KEY FILE (#1.5218) (Required)

              Primary Key   
              LAST EDITED:      SEP 26, 1996 
              DESCRIPTION:
                                IEN of primary key element in SQLI_PRIMARY_KEY of foreign table 

              WRITE AUTHORITY:  ^

1.5219,2      F_CLM_ELEMENT          0;3 POINTER TO SQLI_COLUMN FILE (#1.5217) (Required)

              Column   
              LAST EDITED:      SEP 26, 1996 
              DESCRIPTION:
                                IEN of column of this table in SQLI_COLUMN which matches foreign PK 

              WRITE AUTHORITY:  ^


      FILES POINTED TO                      FIELDS

SQLI_COLUMN (#1.5217)             F_CLM_ELEMENT (#2)

SQLI_PRIMARY_KEY (#1.5218)        F_PK_ELEMENT (#1)

SQLI_TABLE_ELEMENT (#1.5216)      F_TBL_ELEMENT (#.01)



INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):