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 the names in the NameTable.
ChildTable Stores relationship to family(ies) for each child. A child may have two or more families – e.g., birth and adoptive. Links to PersonTable for child and to FamilyTable for parents.
CitationTable Stores Citation details with links to PersonTable, FamilyTable, and EventTable and to the SourceTable for the sources cited. One record per citation.
ConfigTable Stores File settings, Report settings, Fonts, etc to preserve between sessions.
EventTable Stores details for each Fact/Event with links to Persons, Families having the event and to the FactTypeTable for the Fact properties.
ExclusionTable Stores Problem List items indicated by user as Not a problem.
FactTypeTable Definition of the standard and user-defined Facts related to by the EventTable.
FamilyTable Stores Family pairings, spousal order, and notes.
GroupTable Stores data for Named Groups: ranges of PersonID’s from PersonTable that were marked for the group.
LabelTable Stores labels for Named Groups and probably other labels, too.
LinkTable Probably has to do with New Family Search support and future support for remote Media.
MediaLinkTable Stores relationship between records in MultiMediaTable and Person, Event, Place Tables along with settings for use in reports or scrapbooks, captions, notes (unused?), descriptions.
MultimediaTable Stores path and name to Media files, a type of media code, URL (unused as of, and binary thumbnail for image files.
NameTable Stores name parts for persons in tree, including Alternate Names as separate records (unlimited), primary and privacy settings, birth year and death year.
PersonTable Stores basic data for persons in tree: globally Unique ID as well as internal PersonID, FamilyID of parent family and PersonID of spouse, calculated relationship to other person in tree, privacy and living flags, and general note.
PlaceTable Stores system pre-defined and user-defined Places and Place Details (or sites) with Name, Abbreviation, Normalized Name, geographical coordinates, and notes. Linked from eventtable.
ResearchItemTable Stores
ResearchTable Stores contents of To-Do list with link to PersonTable or FamilyTable, depending on where task was created.
RoleTable Stores system pre-defined and user-defined Roles with sentence templates for most FactTypes, linked from WitnessTable.
SourceTable Stores Citation Source details for each unique source, linked from CitationTable (many to 1 allowed); linked to AddressTable for Source Repository and to SourceTemplateTable for support of Citation data entry and reports.
SourceTemplateTable Stores system pre-defined and user-defined sentence and field templates for different kinds of citation sources, following published guidelines. Linked from SourceTable for support of Citation data entry and reports.
WitnessTable Stores data for individual and family Event sharing among persons in tree and outside the tree, with links to RoleTable (Witness, Doctor, user-defined), EventTable, and to PersonTable (if in tree). Stores note for shared event plus name of person if not in tree. If person is not in tree, nothing of this record appears in reports.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.