RootsMagic 9.0.0.0 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:
PersonTable
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.
PayloadTable
New table added in support of Saved Criteria Search and Saved Criteria Group. So far:
OwnerType
New OwnerType values have been added in support of the new tables. These will be identified as encountered through usage and testing.
| Table | RecType | OwnerType | OwnerID | |
| Payload | 1 (SavedCriteriaSearch) | 8 | 0 | |
| Payload | 2 (SavedCriteriaGroup) | 20 | TagTable.TagValue, GroupTable.GroupID |
Table Specs
This is a tab-delimited result of a query of the tables.
I’m trying to learn more about the Rootsmagic structure so I mocked up this erd diagram of the tables: https://familytreehelper.us/Rootsmagic/index.html They don’t have any foreign keys on their tables so it doesn’t show how they mesh together.