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.