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

DATA          NAME                  GLOBAL        DATA
ELEMENT       TITLE                 LOCATION      TYPE
-----------------------------------------------------------------------------------------------------------------------------------
Names and domains of primary keys, columns and foreign keys.  Each represents the relational concept of an attribute, whose
essential charactaristics are a name (unique by relation) and a domain.  
 
See SQLI_PRIMARY_KEY, SQLI_COLUMN and SQLI_FOREIGN key for more.  


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

POINTED TO BY: C_TABLE_ELEMENT field (#.01) of the SQLI_COLUMN File (#1.5217) 
               P_TBL_ELEMENT field (#.01) of the SQLI_PRIMARY_KEY File (#1.5218) 
               F_TBL_ELEMENT field (#.01) of the SQLI_FOREIGN_KEY File (#1.5219) 
               

CROSS
REFERENCED BY: E_NAME(B), E_DOMAIN(C), E_TABLE(D), E_TYPE(E), E_TYPE(F), E_TABLE(G)



1.5216,.01    E_NAME                 0;1 FREE TEXT (Required)

              Table Element   
              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:
                                Name of table element.  Foreign keys are suffixed _FK or PFK. Primary keys are suffixed _PK.  

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


1.5216,1      E_DOMAIN               0;2 POINTER TO SQLI_DOMAIN FILE (#1.5212) (Required)

              Domain   
              LAST EDITED:      SEP 26, 1996 
              DESCRIPTION:
                                IEN of domain in SQLI_DOMAIN 

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


1.5216,2      E_TABLE                0;3 POINTER TO SQLI_TABLE FILE (#1.5215) (Required)

              Table   
              LAST EDITED:      SEP 26, 1996 
              DESCRIPTION:
                                IEN of table in SQLI_TABLE. Required.  

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

              CROSS-REFERENCE:  1.5216^G^MUMPS 
                                1)= S ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)=""
                                2)= K ^DMSQ("E","G",X,$P(^DMSQ("E",DA,0),U),DA)
                                Table element by table by name 



1.5216,3      E_TYPE                 0;4 SET (Required)

              Type   
                                'C' FOR Column; 
                                'P' FOR Primary key; 
                                'F' FOR Foreign key; 
              LAST EDITED:      SEP 26, 1996 
              DESCRIPTION:
                                C for column, P for primary key, or F for foreign key 

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

              CROSS-REFERENCE:  1.5216^F^MUMPS 
                                1)= S ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)=""
                                2)= K ^DMSQ("E","F",$P(^DMSQ("E",DA,0),U,3),X,DA)
                                Table element by table by type 



1.5216,4      E_COMMENT              0;5 FREE TEXT

              Comment   
              INPUT TRANSFORM:  K:$L(X)>60!($L(X)<3) X
              LAST EDITED:      SEP 26, 1996 
              HELP-PROMPT:      Answer must be 3-60 characters in length. 
              DESCRIPTION:
                                A short description of the element 

              WRITE AUTHORITY:  ^


      FILES POINTED TO                      FIELDS

SQLI_DOMAIN (#1.5212)             E_DOMAIN (#1)

SQLI_TABLE (#1.5215)              E_TABLE (#2)



INPUT TEMPLATE(S):

PRINT TEMPLATE(S):

SORT TEMPLATE(S):

FORM(S)/BLOCK(S):