Global: ^DMSQ("F"

FileMan FileNo	FileMan Filename	Package
1.5219	SQLI_FOREIGN_KEY	VA FileMan

FileMan FileNo

FileMan Filename

Package

1.5219

SQLI_FOREIGN_KEY

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.

Package	Total	FileMan Files
VA FileMan	3	SQLI_COLUMN(#1.5217)[2] SQLI_TABLE_ELEMENT(#1.5216)[.01] SQLI_PRIMARY_KEY(#1.5218)[1]

Package

Total

FileMan Files

Fields, Total: 3

Field # Name Loc Type Details

Field #	Name	Loc	Type	Details
.01	F_TBL_ELEMENT	0;1	POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216)	**********************REQUIRED FIELD********************** SQLI_TABLE_ELEMENT(#1.5216) 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	F_PK_ELEMENT	0;2	POINTER TO SQLI_PRIMARY_KEY FILE (#1.5218)	**********************REQUIRED FIELD********************** SQLI_PRIMARY_KEY(#1.5218) LAST EDITED: `SEP 26, 1996` DESCRIPTION: `IEN of primary key element in SQLI_PRIMARY_KEY of foreign table` `WRITE AUTHORITY: ^`
2	F_CLM_ELEMENT	0;3	POINTER TO SQLI_COLUMN FILE (#1.5217)	**********************REQUIRED FIELD********************** SQLI_COLUMN(#1.5217) LAST EDITED: `SEP 26, 1996` DESCRIPTION: `IEN of column of this table in SQLI_COLUMN which matches foreign PK` `WRITE AUTHORITY: ^`

F_TBL_ELEMENT

0;1

POINTER TO SQLI_TABLE_ELEMENT FILE (#1.5216)

************************REQUIRED FIELD************************

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)

F_PK_ELEMENT

0;2

POINTER TO SQLI_PRIMARY_KEY FILE (#1.5218)

************************REQUIRED FIELD************************

LAST EDITED: SEP 26, 1996
DESCRIPTION:
IEN of primary key element in SQLI_PRIMARY_KEY of foreign table
WRITE AUTHORITY: ^

F_CLM_ELEMENT

0;3

POINTER TO SQLI_COLUMN FILE (#1.5217)

************************REQUIRED FIELD************************

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