This branch of the repo describes the ver 11 database schema See other branches for other schema versions.
RootsMagic software, published by RootsMagic Inc. https://RootsMagic.com is a genealogy research project management tool used by amateur and professional genealogists to build family trees.
RootsMagic is distinguished by its use of an unencrypted SQLite database as its storage file format. That makes the user's data available to third party tools and applications. One won't have to worry about one's data being locked up in a proprietary storage format.
The information in this repository was created by the community of RootsMagic users.
If you are interested in SQL access to the RootsMagic database, you should become familiar with the web site https://SQLiteToolsForRootsMagic.com
Besides interesting blog posts, there is a user forum for discussion and Q & A.
The forum format allows a easy exchange of ideas and posting of SQL statements, but it does not lend itself towards creating documentation and keeping it current. That's why I am starting this project where anyone can contribute, fix errors, and fill in the gaps. Everything is under version control, so we can keep current docs for all future RM releases in separate branches.
contains information used by the files in the Tables folder.
One file per schema table.
- Table name at the top.
- Purpose section. A one liner giving summary of what this table does.
- the DDL used to create the table, as generated by the "SQLite Expert" app.
- a list of the columns with the datatype.
- a Notes section which includes another list of the columns with column type notes, and then, free form notes another list.
- A Lookup Tables section, if the table has a field that uses pre-defined values.
- An Open Questions section which makes uncertainty more obvious.
- A DONE marker with a level number. starting at 1 and increasing, here to help order what needs to be fixed next.
RM Date, Sort Date and UTCModDate files include format and code.
Very useful info on how to interpret and manipulate date data in RM.
Shows data initially created by RootsMagic when it generates an empty database.
Show how the RM DB schema has changed from ver 7 to the present.
Contains SQL code to create tables that do not exist in the standard RootsMagic database. See the ReadMe file in that folder. That's why it's not in the main RootsMagic Database folder here in the repo.
I have not investigated the RootsMagic "LDS Options".
I make no guarantee that this information is correct. I appreciate any corrections and pull requests.
In case it's not obvious, the table files, like this file are in MarkDown format (file extension.md) https://github.github.com/gfm/#what-is-github-flavored-markdown-
The easiest way to view these files in the rendered form is by opening then from a GitHub repository.
To edit them, open the raw format version. There are lots of text editors that will also display them in the rendered form. e.g. Visual Studio Code, recent releases of the Windows Notepad app also display markdown files.