RootsMagic 188.8.131.52 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.
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.
|Payload||2 (SavedCriteriaGroup)||20||TagTable.TagValue, GroupTable.GroupID|
This is a tab-delimited result of a query of the tables.
One Reply to “RM9 Data Definitions #datadefinitions”
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.