STANDARD DATA DICTIONARY #1.5215 -- SQLI_TABLE FILE 3/24/25 PAGE 1
STORED IN ^DMSQ("T", *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 22.2)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
Descriptor of a set of table elements: Includes name and file no. (See SQLI_TABLE_ELEMENTS). Each ^DD(DA) represents a table in a
relational model of FileMan. Further, each index represents a table.
Each schema contains multiple tables. Each table contains just one primary key, but multiple columns, foreign keys and indicies.
DD ACCESS: ^
WR ACCESS: ^
DEL ACCESS: ^
LAYGO ACCESS: ^
POINTED TO BY: DM_TABLE field (#3) of the SQLI_DOMAIN File (#1.5212)
T_MASTER_TABLE field (#3) of the SQLI_TABLE File (#1.5215)
E_TABLE field (#2) of the SQLI_TABLE_ELEMENT File (#1.5216)
CROSS
REFERENCED BY: T_NAME(B), T_FILE(C), T_GLOBAL(D), T_MASTER_TABLE(E)
1.5215,.01 T_NAME 0;1 FREE TEXT (Required)
Table
INPUT TRANSFORM: K:$L(X)>30!($L(X)<3)!'($TR(X,"_")?1U.UN) X
LAST EDITED: AUG 20, 1996
HELP-PROMPT: Answer must be 3-30 characters in length.
DESCRIPTION:
Table name must be a valid SQL identifier, unique by schema
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5215^B
1)= S ^DMSQ("T","B",$E(X,1,30),DA)=""
2)= K ^DMSQ("T","B",$E(X,1,30),DA)
1.5215,1 T_SCHEMA 0;2 POINTER TO SQLI_SCHEMA FILE (#1.521) (Required)
Schema
LAST EDITED: SEP 13, 1996
DESCRIPTION:
IEN in SQLI_SCHEMA of the schema to which this table belongs.
WRITE AUTHORITY: ^
1.5215,2 T_COMMENT 0;3 FREE TEXT
Description
INPUT TRANSFORM: K:$L(X)>70!($L(X)<3) X
LAST EDITED: SEP 13, 1996
HELP-PROMPT: Answer must be 3-70 characters in length.
DESCRIPTION:
A short description of the table
WRITE AUTHORITY: ^
1.5215,3 T_MASTER_TABLE 0;4 POINTER TO SQLI_TABLE FILE (#1.5215)
Master Table
LAST EDITED: SEP 13, 1996
HELP-PROMPT: Enter only if this table is an index
DESCRIPTION:
The table of which this table is an index. (Only index tables)
TECHNICAL DESCR:
In SQL, and in the relational model, an index is just a table.
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5215^E
1)= S ^DMSQ("T","E",$E(X,1,30),DA)=""
2)= K ^DMSQ("T","E",$E(X,1,30),DA)
Table by master table
1.5215,4 T_VERSION_FM 0;5 NUMBER
Version
INPUT TRANSFORM: K:+X'=X!(X>999999999)!(X<1)!(X?.E1"."1N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 1 and 999999999, 0 Decimal Digits
DESCRIPTION:
The version number is updated by FileMan when ^DD or ^DIC changes.
WRITE AUTHORITY: ^
1.5215,5 T_ROW_COUNT 0;6 NUMBER
Row Count
INPUT TRANSFORM: K:+X'=X!(X>999999999)!(X<0)!(X?.E1"."1N.N) X
LAST EDITED: SEP 26, 1996
HELP-PROMPT: Type a Number between 0 and 999999999, 0 Decimal Digits
DESCRIPTION:
This field should contain an estimate of the number of rows in the table
WRITE AUTHORITY: ^
1.5215,6 T_FILE 0;7 NUMBER (Required)
Source File
INPUT TRANSFORM: K:+X'=X!(X>999999999)!(X<0)!(X?.E1"."10N.N) X
OUTPUT TRANSFORM: S Y=$S('Y:"",$D(^DIC(+Y)):$P(^(+Y,0),U),1:$O(^DD(+Y,0,"NM","")))
LAST EDITED: SEP 08, 1996
HELP-PROMPT: Type a Number between 0 and 999999999, 9 Decimal Digits
DESCRIPTION:
FileMan file number from which table is derived.
TECHNICAL DESCR:
This may be a subfile number
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5215^C
1)= S ^DMSQ("T","C",$E(X,1,30),DA)=""
2)= K ^DMSQ("T","C",$E(X,1,30),DA)
Table by source file index
1.5215,7 T_UPDATE 0;8 DATE
Last Updated
INPUT TRANSFORM: S %DT="EX" D ^%DT S X=Y K:Y<1 X
LAST EDITED: AUG 21, 1996
DESCRIPTION:
Date last updated.
WRITE AUTHORITY: ^
1.5215,8 T_GLOBAL 1;E1,245 MUMPS
Global Root
INPUT TRANSFORM: K:$L(X)>245 X D:$D(X) ^DIM
LAST EDITED: SEP 26, 1996
HELP-PROMPT: A valid M global variable name using {K} for subscripts
DESCRIPTION:
Global variable name. {K} stands for a subscript E.g.: ^DIC(9.4,{K},3,{K},4,{K})
TECHNICAL DESCR:
Used to piece out global fragments for columns
WRITE AUTHORITY: ^
CROSS-REFERENCE: 1.5215^D
1)= S ^DMSQ("T","D",$E(X,1,30),DA)=""
2)= K ^DMSQ("T","D",$E(X,1,30),DA)
Table by global name. Used for structural study.
FILES POINTED TO FIELDS
SQLI_SCHEMA (#1.521) T_SCHEMA (#1)
SQLI_TABLE (#1.5215) T_MASTER_TABLE (#3)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):