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 5.0.0.6), 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. |