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	5	DMSQF1 DMSQF2 DMSQP3 DMSQP5 DMSQT

Package

Total

Routines

VA Fileman

DMSQF1 DMSQF2 DMSQP3 DMSQP5 DMSQT

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

Customize PDF page

Package: VA Fileman

Global: ^DMSQ("F"

Information

Description

Directly Accessed By Routines, Total: 5

Pointer To FileMan Files, Total: 3

Fields, Total: 3