RM+Database+Design

=RootsMagic 4-7 Database Design=

You will need to know a little about the RootsMagic database to design your own queries and modify others to suit your needs.


 * File Types ||  || installed and created by RootsMagic 4+ ||
 * each .rmgc database file || Table Summaries || role of each table in the database ||
 * || Database System Catalog || tables and indexes along with SQL commands for their creation ||
 * || Data Definitions || field names and types, indexes, and keys from above in tabular form, expanded with typical values and notes on each field ||
 * || Fact Types || content of fresh //facttypetable// ||
 * || Role Types || content of fresh //witnesstable// ||
 * RootsMagic.st || Source Templates || external file that defines built-in Citation Source templates in //sourcetemplatetable// ||
 * //databasename//.DUP || Duplicate Search Merge Database || temporary database with same filename as .rmgc file, created during Duplicate Search Merge ||

Database Documents
Version Monitoring: RM4 RM5 RM6 Database System Catalog: RM4 RM5 RM6 The following contain all versions, more or less. Table Summaries Data Definitions Fact Types Role Types Source Templates ConfigTable RecID 1 Duplicate Search Merge Database Most of the spreadsheets used in the above pages are from the workbook: Database Design Spreadsheets. Refer to to it for latest updates.