GLOBAL MAP DATA DICTIONARY #.31 -- KEY FILE 6/27/25 PAGE 1 STORED IN ^DD("KEY", (148 ENTRIES) SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 22.2) ----------------------------------------------------------------------------------------------------------------------------------- This file stores information about keys on a file or subfile. A key is a set of one or more fields that uniquely identifies a record in a file. If more than one set of fields can uniquely identify a record, one of those sets should be designated the primary key; all others should be designated secondary keys. The primary key is the principal means of identifying records in the file. To allow FileMan to enforce key uniqueness, the database designer must define a regular index that consists of all the fields that make up the key. This index is called the uniqueness index. All key fields must have values. They cannot be null. CROSS REFERENCED BY: FILE(B) INDEXED BY: FILE & PRIORITY (AP), UNIQUENESS INDEX (AU), FILE & NAME (BB), FILE & FIELD (F) ^DD("KEY",D0,0)= (#.01) FILE [1N] ^ (#.02) NAME [2F] ^ (#1) PRIORITY [3S] ^ (#3) UNIQUENESS INDEX [4P:.11] ^ ^DD("KEY",D0,2,0)=^.312IA^^ (#2) FIELD ^DD("KEY",D0,2,D1,0)= (#.01) FIELD [1F] ^ (#.02) FILE [2N] ^ (#1) SEQUENCE NUMBER [3N] ^ INPUT TEMPLATE(S): PRINT TEMPLATE(S): SORT TEMPLATE(S): FORM(S)/BLOCK(S): ^DIST(.403,.3101)= DIKK EDIT ^DIST(.404,.310101)= DIKK EDIT HDR ^DIST(.404,.310102)= DIKK EDIT MAIN ^DIST(.404,.310103)= DIKK EDIT FIELD HDR ^DIST(.404,.310104)= DIKK EDIT FIELD ^DIST(.404,.310105)= DIKK EDIT UI IDENTIFIER ^DIST(.404,.310106)= DIKK EDIT UNIQUENESS INDEX ^DIST(.404,.310107)= DIKK EDIT UI HDR ^DIST(.404,.310108)= DIKK EDIT UI ^DIST(.404,.310109)= DIKK EDIT UI FIELD COLUMN HDR ^DIST(.404,.31011)= DIKK EDIT UI FIELD REP ^DIST(.404,.310111)= DIKK EDIT UI FIELD CRV