Tag: ###datadefinitions

Date Formats #datadefinitions #date #sortdate

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 –…

Read the full article

Date Last Edited #date #datadefinitions

Decode the Last Edited Date for Persons Although the data definition for EditDate in the PersonTable has been divined for almost as long as this wiki has existed, it seems that no one has published a SQLite query that incorporates it. Here is one that provides the algorithm using SQLite expressions described at http://www.sqlite.org/lang_datefunc.html. SELECT…

Read the full article

Role Types #datadefinitions #roles

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…

Read the full article

Fact Types #datadefinitions

RootsMagic 4+ Built-In Fact Types The built-in fact types for RM4 and later can be found in FactTypeTable with FactTypeID less than 1000. User-defined/custom types are assigned values of 1000 and higher by the program when created. Built-in facts and their unedited values within the table are as follows: FactTypeID OwnerType Name Abbrev GedcomTag UseValue…

Read the full article

RM5 Table Summaries #datadefinitions

The following non-system tables currently reside in the RM5 database: Name Description AddressLinkTable Translates OwnerID from various tables to the key AddressID in AddressTable. AddressTable Stores Addresses for Persons in the tree, Repositories, and other entities that need not be in the tree. Note that the Name in this table is not the same as…

Read the full article

RM5 Database System Catalog #datadefinitions

A singular system table, sqlite_master, resides in a SQLite database. The table in the RootsMagic 5 database essentially defines the RootsMagic 5 database tables, indices, and fields, as below. Differences in structure with RootsMagic 4 include the addition of a new table, ResearchItemTable (and its index), to incorporate the newly-incorporated Research Log feature. In addition,…

Read the full article