Logo Home    Page list

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 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.
www.000webhost.com