RM9 Data Definitions #datadefinitions

RootsMagic was released on Feb 27, 2023 with some new features necessitating changes to the database design. All previous version #database files undergo an upgrade procedure to the RM9 structure and are not backward compatible. However, #RM9 and #RM8 table structures are identical with the following exceptions:


9 new fields named color1, …, color9 have been added in support of the ColorCode sets 1 through 10. The original “color” field is set 1.

FanTable, FanTypeTable

New tables added in support of the new Associations feature. They bear a resemblance, respectively, to the EventTable and FactTypeTable.


New table added in support of Saved Criteria Search and Saved Criteria Group. So far:


New OwnerType values have been added in support of the new tables. These will be identified as encountered through usage and testing.

Payload1 (SavedCriteriaSearch)80
Payload2 (SavedCriteriaGroup)20TagTable.TagValue, GroupTable.GroupID

Table Specs

This is a tab-delimited result of a query of the tables.

One Reply to “RM9 Data Definitions #datadefinitions

Leave a Reply

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