RM Database Design #datadefinitions #database

RootsMagic 4+ 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. A picture is worth many words so here is a series of Entity Relationship Diagrams by different authors:

RM9 Database Diagram #rm9 #database

Roots Magic 8 Database – Database Diagram

Entity Relationship Diagram for RootsMagic v7.5+ by Bill Girimonti, forum 2019-09-21

The following dig deeper into details but are not necessarily updated to the latest version:

File Typesinstalled and created by RootsMagic 4+
each .rmgc database fileTable Summariesrole of each table in the database
Database System Catalogtables and indexes along with SQL commands for their creation
Data Definitionsfield names and types, indexes, and keys from above in tabular form, expanded with typical values and notes on each field
Fact Typescontent of fresh facttypetable
Role Typescontent of fresh witnesstable
RootsMagic.stSource Templatesexternal file that defines built-in Citation Source templates in sourcetemplatetable
databasename.DUPDuplicate Search Merge Databasetemporary 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.