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

VA FileMan

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.

Package	Total	Routines
VA FileMan	7	DMSQF1 DMSQF2 DMSQP3 DMSQP5 DMSQT YEAR ^DMSQ("F"

Package

Total

Routines

VA FileMan

DMSQF1 DMSQF2 DMSQP3 DMSQP5 DMSQT YEAR ^DMSQ("F"

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

VA FileMan

SQLI_COLUMN(#1.5217)[2] SQLI_TABLE_ELEMENT(#1.5216)[.01] SQLI_PRIMARY_KEY(#1.5218)[1]

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: ^`

.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)

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: ^

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: ^

Name	Line Occurrences (* Changed, ! Killed)
^DMSQ("F" - [#1.5219]	.01(XREF 1S), .01(XREF 1K)

Name

Line Occurrences (* Changed, ! Killed)

^DMSQ("F" - [#1.5219]

.01(XREF 1S), .01(XREF 1K)

Local Variables

Legend:

>>	Not killed explicitly
*	Changed
!	Killed
~	Newed

Name	Field # of Occurrence
>> DA	.01(XREF 1S), .01(XREF 1K)
>> X	.01(XREF 1S), .01(XREF 1K)

Customize PDF page

Package: VA FileMan

Global: ^DMSQ("F"

Information

Description

Directly Accessed By Routines, Total: 7

Pointer To FileMan Files, Total: 3

Fields, Total: 3

Global Variables Directly Accessed

Local Variables

Legend: