Exploit your RootsMagic family tree database with SQLite Tools
RootsMagic 4+ Data Definitions See spreadsheets “DataDefsMstr” and “DataDefsFieldSort” on Database Design Spreadsheets. Discussions & comments from Wikispaces site romermb Adding To/Updating File romermb 08 January 2010 21:35:48 A few of us so far have been trying to add the Notes, etc details to the various table fields in the file referenced in this page.…
RootsMagic 4+ Database Tables – Summary See the sheet “TblSum” on Database Design Spreadsheets.
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 –…
The database documentation was done largely on RootsMagic version 6.0.0.2. It’s unlikely that the database schema will change through successive updates. However, any changes may be detected by opening a database created by each version with a SQLite manager, then exporting either a query of the full sqlite_master table or the database schema (just the…
Full screen. | Google Sheet
Storage formats Within the RootsMagic 4 database, several date-related fields exist. These fields can be grouped into into four different storage types: FLOAT, with the integer part representing number of days since 1899 Dec 31 and fractional part representing time of day EventTable – EditDate LinkTable – extDate (presumably) NameTable – EditDate (presumably) PersonTable –…
RM8 replaced Edit Date with UTCModDate Previous versions had an EditDate column in a few tables. In #RM8, these have been replaced by UTCModDate which is present in most tables and appears to serve the same functions, one of which is to populate the “Date Edited” field in the People List view. The “Date Edited”…
RootsMagic 4+ Built-In Roles The built-in roles for RM4 and later can be found in RoleTable with RoleID up through 58. User-defined/custom types are assigned values of 59 and higher by the program when created. Built-in roles and their unedited values within the table are as follows: RoleID RoleName EventType RoleType Sentence 1 Witness 1…
RootsMagic 4+ Built-In Fact Types 2023-05-22 updated to RM9 The built-in fact types for RM4 and later can be found in the FactTypeTable with FactTypeID less than 1000. User-defined/custom types are assigned values of 1000 and higher by the program when created. Between RM4 and RM9, only the 902-Associations fact type has been added. There…
A singular system table, sqlite_master, resides in a SQLite database. This table in the RootsMagic 6 database essentially defines the RootsMagic 6 database tables, indices, and fields, as below. The difference in structure with RootsMagic 5 is the addition of one new table, URLTable (no index) for WebTags. type name tbl_name rootpage sql table…