DEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
TableFieldRM
4		RM
5		RM
6,7		RM
7.5		RM
8		RM
9		RM 10TypeKey/IndexTypical Values
10		Typical Values
9		Typical Values
8		Typical Values
4-7		Notes 10Notes
9		Notes
8		Notes
4-7
2
AddressLinkTableLinkIDYYYYYYYIntegerPrimary Key1,2,3...1,2,3...1,2,3...1,2,3...Link Identification Number, sequentially ordered
3
AddressLinkTableOwnerTypeYYYYYYYInteger0,1,3,60,1,3,60,1,3,6,Others0,1,3,6,Others?0 = Person (Address of Person Fact from Edit Person Window),
1 = Family (Address of Spouse / Parents from Edit Person Window),
3 = Source (Repository),
6 = Task (Address or Repository)
4
AddressLinkTableAddressIDYYYYYYYInteger1,2,3...1,2,3...1,2,3...1,2,3...Links to AddressID in AddressTable
5
AddressLinkTableOwnerIDYYYYYYYInteger1,2,3...1,2,3...0, 1, 3, 61,2,3...Link based on OwnerType:
0 = PersonTable.PersonID,
1 = FamilyTable.FamilyID,
3 = SourceTable.SourceID,
6 = TaskTable.TaskID
6
AddressLinkTableAddressNumYYYYYYYInteger001, 21,20Address Number (1 = Address [Primary], from Edit Address screen (OwnerType = 0 or 1);
Repository [Primary], from Edit Repository screen (OwnerType = 3);
Address or Repository, from Edit Address or Edit Repository screen (OwnerType = 6);
2 = Address [Secondary], from Edit Address screen (OwnerType = 0 or 1);
Repository [Secondary], from Edit Repository screen (OwnerType = 3))
7
AddressLinkTableDetailsYYYYYYYTextBlankBlankText or NullText or NullNot ImplementedDetails (Call number from Repositories screen (OwnerType = 3); NULL, otherwise)
8
AddressLinkTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
9
AddressTableAddressIDYYYYYYYIntegerPrimary Key1,2,3...1,2,3...1,2,3...1,2,3...Address Identification Number
10
AddressTableAddressTypeYYYYYYYInteger0,10,10,10,10 = Person or Family,
1 = Repository
11
AddressTableNameYYYYYYYTextidxAddressNameUser DefinedUser DefinedTextTextName, from Edit Address pane or Edit Repository pane.
12
AddressTableStreet1YYYYYYYTextUser DefinedUser DefinedTextTextStreet address [first line], from Edit Address pane or Edit Repository pane.
13
AddressTableStreet2YYYYYYYTextUser DefinedUser DefinedTextTextStreet address [second line], from Edit Address pane or Edit Repository pane.
14
AddressTableCityYYYYYYYTextUser DefinedUser DefinedTextTextCity, from Edit Address pane or Edit Repository pane.
15
AddressTableStateYYYYYYYTextUser DefinedUser DefinedTextTextState, from Edit Address pane or Edit Repository pane.
16
AddressTableZipYYYYYYYTextUser DefinedUser DefinedTextTextPostal Code, from Edit Address pane or Edit Repository pane.
17
AddressTableCountryYYYYYYYTextUser DefinedUser DefinedTextTextCountry, from Edit Address pane or Edit Repository pane.
18
AddressTablePhone1YYYYYYYTextUser DefinedUser DefinedTextTextPhone, from Edit Address pane or Edit Repository pane.
19
AddressTablePhone2YYYYYYYTextUser DefinedUser DefinedTextTextCell phone, from Edit Address pane or Edit Repository pane.
20
AddressTableFaxYYYYYYYTextUser DefinedUser DefinedTextTextFax, from Edit Address pane or Edit Repository pane.
21
AddressTableEmailYYYYYYYTextUser DefinedUser DefinedTextTextEmail, from Edit Address pane or Edit Repository pane.
22
AddressTableURLYYYYYYYTextUser DefinedUser DefinedTextTextWebsite, from Edit Address pane or Edit Repository pane.
23
AddressTableLatitudeYYYYYYYIntegerUser Defined4367583330Not implementedLatitude, e.g., Toronto, Canada
24
AddressTableLongitudeYYYYYYYIntegerUser Defined-7939694440Not implementedLongitude, e.g., Toronto, CanadaLongitude, not currently used?
25
AddressTableNoteYYYYYYYTextUser DefinedUser DefinedTextTextNote, from Edit Address pane or Edit Repository pane.
User Interface supports line breaks and formatting tags.
26
AddressTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
27
AncestryTableLinkIDNNNNYYYIntegerPrimary Key1,2,3...1,2,3...1,2,3...LinkID Identification Number
28
AncestryTableLinkTypeNNNNYYYInteger0, 4, 110, 4, 110, 4, 110 = Person,
4 = Citation,
11 = Media
29
AncestryTablermIDNNNNYYYIntegeridxLinkAncestryRmId1,2,3...1,2,3...1,2,3...Link based on LinkType:
0 = PersonTable.PersonID,
4 = CitationTable.CitationID,
11 = MultiMediaTable.MediaID
30
AncestryTableanIDNNNNYYYTextidxLinkAncestryanIDFormatted stringFormatted string1,2,3...Person = [d]{12}:[d]{4}:[d]{9} - e.g.: 121212121212:1030:123456789,
Citation, origin RM = [d]:9000:[d] (length varies),
Citation, origin Ancestry = [d]:[d]
Media = Ancestry assigned ID (matches filename for media downloaded from Ancestry)		Ancestry ID from TreeShare connection
31
AncestryTableModifiedNNNNYYYInteger0, 10, 1For LinkType=0 (Person):
0 = No modification detected or 'Mark as not changed' button has been selected in Treeshare,
1 = Change identified in RM db or in Ancestry via Treeshare notification. Person’s status appears as changed in Treeshare.
32
AncestryTableanVersionNNNNYYYTextNull or Hex StringNull or Hex String1, 2, 3...Hex code where LinkType=0 (Person),
Otherwise NULL		Ancestry Version
33
AncestryTableanDateNNNNYYYFloat0.00.0XML code0Ancestry Date - Date Record (See ConfigTable RecID 1)
34
AncestryTableStatusNNNNYYYInteger000
35
AncestryTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
36
AncestryTableTreeIDNNNNNNYTextBlankNot Implemented
37
ChildTableRecIDYYYYYYYIntegerPrimary Key1,2,3...1,2,3...1,2,3...1,2,3...Record number in childtable
38
ChildTableChildIDYYYYYYYIntegeridxChildID1,2,3...1,2,3...1,2,3...1,2,3...Link to PersonID in PersonTable
39
ChildTableFamilyIDYYYYYYYIntegeridxChildFamilyID1,2,3...1,2,3...1,2,3...1,2,3...Link to FamilyID in FamilyTableFamilyID - links to FamilyID in familytable or MRIN
40
ChildTableRelFatherYYYYYYYInteger0,1,2,...0,1,2,...0,1,2,...0,1,2,...Relationship to Father as defined in Parents section of Edit Person:
0 = Birth,
1 = Adopted,
2 = Step,
3 = Foster,
4 = Related,
5 = Guardian,
6 = Sealed,
7 = Unknown		Relationship to Father in Family:
0 - Birth,
1 - Adopted,
2 - Step,etc
41
ChildTableRelMotherYYYYYYYInteger0,1,2,...0,1,2,...0,1,2,...0,1,2,...Relationship to Mother as defined in Parents section of Edit Person:
(Values same as RelFather)		Relationship to Mother in Family:
0 - Birth,
1 - Adopted,
2 - Step,etc
42
ChildTableChildOrderYYYYYYYIntegeridxChildOrder0,1,2,3,...0,1,2,3,...0,1,2,3...0,1,2,3...When number of Children=1:
0 = Child added to family with Add Father or Add Mother action,
1000 = Child added to family with Add Child action;
Else, once number of Children >1 value matches order in Family view.		0 means in record order;
1,2,... revises the order for the family but 1000 also observed for child added w/o birthdate,
and 501 sometimes noted when no other children in family.
43
ChildTableIsPrivateYYYYYYYInteger000, 10,1Not Implemented0 if Private is not checked in Parents pane of Edit Person Person dialog
1 if Private checked in Parents pane of Edit Person dialog.
Effect on reports is not apparent.		1 if Private checked in Parents pane of Edit Person dialog. Effect on reports is not apparent.
44
ChildTableProofFatherYYYYYYYInteger0,1,2,30,1,2,30 ,1 ,2 ,30,1,2,3Set by Proof listbox in Parents pane of Edit Persons.
0 - Blank,
1 - Proven,
2 - Disproven,
3 - Disputed
45
ChildTableProofMotherYYYYYYYInteger0,1,2,30,1,2,30 ,1 ,2 ,30,1,2,3Set by Proof listbox in Parents pane of Edit Persons.
0 - Blank,
1 - Proven,
2 - Disproven,
3 - Disputed
46
ChildTableNoteYYYYYYYBlob/TextBlankfreeform textNot Implemented
47
ChildTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
48
CitationLinkTableLinkIDNNNNYYYIntegerPrimary Key1,2,3,...1,2,3,...Link identification number
49
CitationLinkTableCitationIDNNNNYYYInteger1,2,3,...1,2,3,...1, 2, 3...Link to CitationTable.CitationID
50
CitationLinkTableOwnerTypeNNNNYYYInteger0,1,2,6,7,190,1,2,6,7,190, 1, 2, 7 0 = Person,
1 = Family,
2 = Event,
6 = Task,
7 = Name,
19 = Association		0 =
1 =
2 =
7 =
51
CitationLinkTableOwnerIDNNNNYYYIntegeridxCitationLinkOwnerID0Link to Primary Key of table based on OwnerType:
0 = PersonTable.PersonID,
1 = FamilyTable.FamilyID,
2 = EventTable.EventID,
6 = TaskTable.TaskID,
7 = NameTable.NameID,
19 = FanTable.FanID
52
CitationLinkTableSortOrderNNNNYYYIntegerNull, or
0		Null, or
0		Not Implemented:
Null = Legacy data,
0 = New table entry
53
CitationLinkTableQualityNNNNYYYText[PS~]{DIN~][OX~][PS~]{DIN~][OX~]3-Character Quality of this information:
1st = (Info): P = Primary, S = Secondary,~ = Don't know
2nd = (Evidence): D = Direct, I = Indirect, N = Negative, ~ = Don't know
3rd = (Source): O = Original, X = Derivative, ~ = Don't know
54
CitationLinkTableIsPrivateNNNNYYYInteger00Not Implemented0 if Private is not checked in Parents pane of Edit Person Person dialog
1 if Private checked in Parents pane of Edit Person dialog.
Effect on reports is not apparent.
55
CitationLinkTableFlagsNNNNYYYInteger000, 1Not Implemented0 =
1 =
56
CitationLinkTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
57
CitationTableCitationIDYYYYYYYIntegerPrimary Key1,2,3...1,2,3...1, 2, 3...1,2,3...Citation Identification Number
58
CitationTableOwnerTypeYYYYNNNInteger0,1,2,7Owner Type (0 = Personal, 1 = Family, 2 = Event, 7 = Alternate Name)
59
CitationTableSourceIDYYYYYYYIntegeridxCitationSourceID1,2,3...1,2,3...1, 2, 3...1,2,3...Link to SourceID of SourceTable
60
CitationTableOwnerIDYYYYNNNIntegeridxCitationOwnerID1,2,3...Owner Identification Number (linking to PersonID of PersonTable for OwnerType = 0, FamilyID of FamilyTable for OwnerType = 1, EventID of EventTable for OwnerType = 2, NameID of NameTable for OwnerType = 7)
61
CitationTableQualityYYYYNNNText``~``~``~``, etc (ignore double backticks needed for wiki compatability)Information, Evidence, and Source Quality of this information; from Quality of this information screen (First Character: P = Primary,
S = Secondary,
~ = Don't know; Second: D = Direct, I = Indirect, N = Negative, ~ = Don't know; Third: O = Original, X = Derivative, ~ = Don't know)
62
CitationTableIsPrivateYYYYNNNInteger0not currently used?
63
CitationTableCommentsYYYYYYYBlob/TextUser DefinedUser DefinedTextTextDetail Comment from Edit Citation pane. User Interface supports line breaks and formatting tags.
64
CitationTableActualTextYYYYYYYBlob/TextUser DefinedUser DefinedTextTextResearch Note from Edit Citation pane. User Interface supports line breaks and formatting tags.
65
CitationTableRefNumberYYYYYYYTextUser DefinedUser DefinedTextTextDetail Ref# from Edit Citation pane.
66
CitationTableFlagsYYYYNNNInteger0not currently used?, all 0
67
CitationTableFieldsYYYYYYYBlobXMLXMLXML codeXML codeCitation Detail field “Names” (from Source template) and “Values” (from Edit Citation pane)
68
CitationTableFootnoteNNNNYYYTextUser DefinedUser DefinedValue from Customize Footnote window, overrides sentence template output. User Interface supports line breaks and formatting tags.
69
CitationTableShortFootnoteNNNNYYYTextUser DefinedUser DefinedValue from Customize Footnote window, overrides sentence template output. User Interface supports line breaks and formatting tags.
70
CitationTableBibliographyNNNNYYYTextUser DefinedUser DefinedValue from Customize Footnote window, overrides sentence template output. User Interface supports line breaks and formatting tags.
71
CitationTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
72
CitationTableCitationNameNNNNYYYTextidxCitationNameUser DefinedUser DefinedIf left blank, field value is auto generated as the concatenation of all Citation Detail fields separated by semi-colons.
73
ConfigTableRecIDYYYYYYYIntegerPrimary Key1, 2, 3...1, 2, 3...1, 2, 3...1,2,3...Record Identification Number
74
ConfigTableRecTypeYYYYYYYIntegeridxRecType1, 2, 3...1, 2, 3...Null, 1, 3, 4, 5, 7Null, 1?-7?Record Type:
1 = Database Configuration settings
3 = Custom Report settings, from Publish menu
4 =
5 = Standard Report settings, from Publish menu
6 = HTML Website settings, from Publish menu
7 = Problem Options, from General Settings menu or Problem Search
9 = Book settings, from Publish menu		Record Type
Null
1 = ?
3 = Custom Report?
4 = ?
5 = Report/List/Chart/Etc?,
7 = Problem List?
75
ConfigTableTitleYYYYYYYTextBuilt-in or
User Defined		Built-in or
User Defined		TextTextTitle - See Row 5 of ConfigTable Tab
76
ConfigTableDataRecYYYYYYYBlobXML codeXML codeXML codeXML codeData Record - See Row 40 of ConfigTable Tab
77
ConfigTableUTCModDateNNNNYYYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		[d]{5}.[d]{10}
e.g.: 44993.9143704283		{5}.{10}Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
78
DNATableRecIDNNNNNNYIntegerPrimary Key1, 2, 3…Record Identification Number
79
DNATableID1NNNNNNYIntegeridxDnaId1,
Foreign Key		1, 2, 3…Person 1, from the DNA Match view of Edit Person Window.
Links to PersonTable.PersonID.
80
DNATableID2NNNNNNYIntegeridxDnaId2,
Foreign Key		1, 2, 3…Person 2, from the DNA Match view of Edit Person Window.
Links to PersonTable.PersonID.
81
DNATableLabel1NNNNNNYTextUser DefinedLabel 1, from the DNA Match view of Edit Person Window.
82
DNATableLabel2NNNNNNYTextUser DefinedLabel 2, from the DNA Match view of Edit Person Window.
83
DNATableDNAProviderNNNNNNYInteger1-6, 998, 999Provider, from the DNA Match view of Edit Person Window:
1 = 23andMe,
2 = Ancestry,
3 = Family Tree DNA,
4 = Living DNA,
5 = My Heritage,
6 = GEDmatch,
998 = Unknown,
999 = Other
84
DNATableSharedCMNNNNNNYFloatUser Defined,
0-4000		Shared Centimorgans (cM), from the DNA Match view of Edit Person Window.
85
DNATableSharedPercentNNNNNNYFloatUser Defined,
0-100		Shared Percentage, from the DNA Match view of Edit Person Window.
86
DNATableLargeSegNNNNNNYFloatUser Defined,
0-500		Largest Segment (cM), from the DNA Match view of Edit Person Window.
87
DNATableSharedSegsNNNNNNYIntegerUser Defined,
0-100		Shared Segments, from the DNA Match view of Edit Person Window.
88
DNATableDateNNNNNNYTextPosition coded string or free text[See Date sheet for additional details.]
89
DNATableRelate1NNNNNNYInteger0-999Relate1, the number of generations between Person 1 (DNATable.ID1) and the Most Recent Common Ancestor (DNATable.CommonAnc). Relate1 and Relate2, taken together with DNATable.CommonAncType, calculate the relationship between the shared DNA Match.
90
DNATableRelate2NNNNNNYInteger0,1,2,...Relate2, the number of generations between Person 2 (DNATable.ID2) and the Most Recent Common Ancestor (DNATable.CommonAnc). Relate1 and Relate2, taken together with DNATable.CommonAncType, calculate the relationship between the shared DNA Match.
[See Table for additional details.]
91
DNATableCommonAncNNNNNNYIntegerForeign Key0,1,2,...Most Recent Common Ancestor (MRCA) of Person1 and Person2 of the DNA Match. Link to Primary Key of table based on DNATable.CommonAncType:
0 = PersonTable.PersonID,
1 = FamilyTable.FamilyID

Note: CommonAnc = 0 when both Relate1 and Relate2 = 0 (ie when no RM-defined Tree Relationship has been identified).
92
DNATable
CommonAncType
NNNNNNYInteger0,1Common Ancestor Type. When DNATable.CommonAnc > 0:
0 = Single MRCA (ie Half Relationship) identified in RM Tree,
1 = Couple MRCA identified in RM Tree

Note: CommonAncType also = 0 when DNATable.CommonAnc=0 (ie when no RM-defined Tree Relationship has been identified).
93
DNATableVerifiedNNNNNNYInteger0Not Implemented
94
DNATableNoteNNNNNNYTextUser DefinedDNA Note, from the DNA Match view of Edit Person Window.
User Interface supports line breaks and formatting tags.
95
DNATableUTCModDateNNNNNNYFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
96
EventTableEventIDYYYYYYYIntegerPrimary Key1,2,3...1,2,3...1, 2, 3...1,2,3...Event Identification NumberRecord number in eventtable. Used to look up witnesses to event (persons sharing the fact) in WitnessTable
97
EventTableEventTypeYYYYYYYIntegeridxOwnerEvent1,2,3...1,2,3...1, 2, 3...1,2,3...Link to FactTypeID in FactTypeTable
98
EventTableOwnerTypeYYYYYYYInteger0,10,10, 10,10 = Person,
1 = Family
99
EventTableOwnerIDYYYYYYYIntegeridxOwnerDate,
idxOwnerEvent		1,2,3...1,2,3...1, 2, 3...1,2,3...Link based on OwnerType:
0 = PersonID in PersonTable,
1 = FamilyID in FamilyTable
100
EventTableFamilyIDYYYYYYYInteger0,1,2,...0,1,2,...0, 1, 2,…0,1,2,...Link based on OwnerType:
0 = not applicable or not assigned to event,
Else = FamilyID in FamilyTable (Set via Parents listbox in Edit Person Fact pane for events such as Adoption or LDS Seal to Parents)