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:
The following dig deeper into details but are not necessarily updated to the latest version:
|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|
Version Monitoring: RM4 RM5 RM6
Database System Catalog: RM4 RM5 RM6
The following contain all versions, more or less.
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.