RootsMagic4+DataDefs.ods
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
RootsMagic 4+ Database Tables Summary
2
3
NameDescription
RM Ver
4
AddressLinkTable
Translates OwnerID from various tables to the key AddressID in AddressTable.4
5
AddressTableStores 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.4
6
ChildTableStores 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.4
7
CitationTableStores Citation details with links to PersonTable, FamilyTable, and EventTable and to the SourceTable for the sources cited. One record per citation.4
8
ConfigTableStores File settings, Report settings, Fonts, etc to preserve between sessions.4
9
EventTableStores details for each Fact/Event with links to Persons, Families having the event and to the FactTypeTable for the Fact properties.4
10
ExclusionTable
Stores Problem List items indicated by user as Not a problem.4
11
FactTypeTableDefinition of the standard and user-defined Facts related to by the EventTable.4
12
FamilyTableStores Family pairings, spousal order, and notes.4
13
GroupTableStores data for Named Groups: ranges of PersonID's from PersonTable that were marked for the group.4
14
LabelTableStores labels for Named Groups and probably other labels, too.4
15
LinkAncestryTable
Identical to LinkTable but specifically for Ancestry TreeShare7.5
16
LinkTableLinks to Family Search Family Tree for matched persons and possible future other online trees4
17
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 in RM4, unused in RM5+.
4
18
MultimediaTable
Stores path and name to Media files, a type of media code, URL (unused as of 4.0.7.1), and binary thumbnail for image files; caption, refnumber, description, date as of RM5.
4
19
NameTableStores name parts for persons in tree, including Alternate Names as separate records (unlimited), primary and privacy settings, birth year and death year.4
20
PersonTableStores 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.4
21
PlaceTableStores system pre-defined and user-defined Places and Place Details (or sites) with Name, Abbreviation, Normalized Name, geographical coordinates, and notes. Linked from eventtable.4
22
ResearchItemTable
Stores Research Items related to Research Logs as of RM55
23
ResearchTable
Stores Research Logs as of RM5; To-Do tasks in RM4.4
24
RoleTableStores system pre-defined and user-defined Roles with sentence templates for most FactTypes, linked from WitnessTable.4
25
SourceTableStores 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.4
26
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.4
27
URLTableStores WebTags6
28
WitnessTableStores 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.4
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...