CDFGHIJKLMNOPQRSTUVWXYZ
1
TableColumnTypeKey/IndexTypical ValuesCommentsProposed UpdateValidated?
2
AddressLinkTableLinkIDIntegerPrimary Key1, 2, 3,...Link Identification Number, sequentially ordered
3
AddressLinkTableOwnerTypeInteger0, 1, 3, 60 = 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
AddressLinkTableAddressIDIntegerForeign Key1, 2, 3,...Links to AddressID in AddressTable
5
AddressLinkTableOwnerIDIntegerForeign Key1, 2, 3,...Link based on OwnerType:
0 = PersonTable.PersonID,
1 = FamilyTable.FamilyID,
3 = SourceTable.SourceID,
6 = TaskTable.TaskID
6
AddressLinkTableAddressNumInteger0
7
AddressLinkTableDetailsTextBlankNot Implemented
8
AddressLinkTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
9
AddressTableAddressIDIntegerPrimary Key1, 2, 3,...Address Identification Number
10
AddressTableAddressTypeInteger0, 10 = Person or Family,
1 = Repository
11
AddressTableNameText Collate RMNOCASEidxAddressNameUser DefinedName, from Edit Address pane or Edit Repository pane. See Change History TabY
12
AddressTableStreet1TextUser DefinedStreet address [first line], from Edit Address pane or Edit Repository pane.
13
AddressTableStreet2TextUser DefinedStreet address [second line], from Edit Address pane or Edit Repository pane.
14
AddressTableCityTextUser DefinedCity, from Edit Address pane or Edit Repository pane.
15
AddressTableStateTextUser DefinedState, from Edit Address pane or Edit Repository pane.
16
AddressTableZipTextUser DefinedPostal Code, from Edit Address pane or Edit Repository pane.
17
AddressTableCountryTextUser DefinedCountry, from Edit Address pane or Edit Repository pane.
18
AddressTablePhone1TextUser DefinedPhone, from Edit Address pane or Edit Repository pane.
19
AddressTablePhone2TextUser DefinedCell phone, from Edit Address pane or Edit Repository pane.
20
AddressTableFaxTextUser DefinedFax, from Edit Address pane or Edit Repository pane.
21
AddressTableEmailTextUser DefinedEmail, from Edit Address pane or Edit Repository pane.
22
AddressTableURLTextUser DefinedWebsite, from Edit Address pane or Edit Repository pane.
23
AddressTableLatitudeIntegerUser DefinedNot implemented
24
AddressTableLongitudeIntegerUser DefinedNot implemented
25
AddressTableNoteTextUser DefinedNote, from Edit Address pane or Edit Repository pane.
User Interface supports line breaks and formatting tags.
26
AddressTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
27
AncestryTableLinkIDIntegerPrimary Key1, 2, 3,...LinkID Identification Number
28
AncestryTableLinkTypeInteger0, 4, 110 = Person,
4 = Citation,
11 = Media
29
AncestryTablermIDIntegerForeign Key,
idxLinkAncestryRmID		1, 2, 3,...Link based on LinkType:
0 = PersonTable.PersonID,
4 = CitationTable.CitationID,
11 = MultiMediaTable.MediaID
30
AncestryTableanIDTextidxLinkAncestryanIDFormatted stringPerson = [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)		See Change History TabY
31
AncestryTableModifiedInteger0, 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
AncestryTableanVersionTextNull or Hex StringHex code where LinkType=0 (Person),
Otherwise NULL
33
AncestryTableanDateFloat0.0
34
AncestryTableStatusInteger0
35
AncestryTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
36
AncestryTableTreeIDTextBlankNot ImplementedSee Change History TabY
37
ChildTableRecIDIntegerPrimary Key1, 2, 3,...Record number in childtable
38
ChildTableChildIDIntegerForeign Key,
idxChildID		1, 2, 3,...Link to PersonID in PersonTable
39
ChildTableFamilyIDIntegerForeign Key,
idxChildFamilyID		1, 2, 3,...Link to FamilyID in FamilyTable
40
ChildTableRelFatherInteger0, 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
41
ChildTableRelMotherInteger0, 1, 2,...Relationship to Mother as defined in Parents section of Edit Person:
(Values same as RelFather)
42
ChildTableChildOrderIntegeridxChildOrder0, 1, 2,...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.
43
ChildTableIsPrivateInteger0Not Implemented
44
ChildTableProofFatherInteger0-3Set by Proof listbox in Parents pane of Edit Persons.
0 - Blank,
1 - Proven,
2 - Disproven,
3 - Disputed
45
ChildTableProofMotherInteger0-3Set by Proof listbox in Parents pane of Edit Persons.
0 - Blank,
1 - Proven,
2 - Disproven,
3 - Disputed
46
ChildTableNoteTextBlankNot Implemented
47
ChildTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
48
CitationLinkTableLinkIDIntegerPrimary Key1, 2, 3,...Link identification number
49
CitationLinkTableCitationIDIntegerForeign Key1, 2, 3,...Link to CitationTable.CitationID
50
CitationLinkTableOwnerTypeInteger0, 1, 2, 6, 7, 19 0 = Person,
1 = Family,
2 = Event,
6 = Task,
7 = Name,
19 = Association
51
CitationLinkTableOwnerIDIntegerForeign Key,
idxCitationLinkOwnerID		1, 2, 3,...Link 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		See Change History TabY
52
CitationLinkTableSortOrderIntegerNull, or
0		Not Implemented:
Null = Legacy data,
0 = New table entry
53
CitationLinkTableQualityText[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
CitationLinkTableIsPrivateInteger0Not Implemented
55
CitationLinkTableFlagsInteger0Not Implemented
56
CitationLinkTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
57
CitationTableCitationIDIntegerPrimary Key1, 2, 3,...Citation Identification Number
58
CitationTableSourceIDIntegerForeign Key,
idxCitationSourceID		1, 2, 3,...Link to SourceID of SourceTable
59
CitationTableCommentsTextUser DefinedDetail Comment from Edit Citation pane. User Interface supports line breaks and formatting tags.
60
CitationTableActualTextTextUser DefinedResearch Note from Edit Citation pane. User Interface supports line breaks and formatting tags.
61
CitationTableRefNumberTextUser DefinedDetail Ref# from Edit Citation pane.
62
CitationTableFootnoteTextUser DefinedValue from Customize Footnote window, overrides sentence template output. User Interface supports line breaks and formatting tags.
63
CitationTableShortFootnoteTextUser DefinedValue from Customize Footnote window, overrides sentence template output. User Interface supports line breaks and formatting tags.
64
CitationTableBibliographyTextUser DefinedValue from Customize Footnote window, overrides sentence template output. User Interface supports line breaks and formatting tags.
65
CitationTableFieldsBlobXMLCitation Detail field “Names” (from Source template) and “Values” (from Edit Citation pane)
66
CitationTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
67
CitationTableCitationNameText Collate RMNOCASEidxCitationNameUser DefinedIf left blank, field value is auto generated as the concatenation of all Citation Detail fields separated by semi-colons.See Change History TabY
68
ConfigTableRecIDIntegerPrimary Key1, 2, 3...Record Identification Number
69
ConfigTableRecTypeIntegeridxRecType1, 2, 3...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
70
ConfigTableTitleTextBuilt-in or
User Defined		Title - See Row 5 of ConfigTable Tab
71
ConfigTableDataRecBlobXML codeData Record - See Row 40 of ConfigTable Tab
72
ConfigTableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5
73
DNATableRecIDIntegerPrimary Key1, 2, 3…Record Identification NumberSee Change History TabY
74
DNATableID1IntegerForeign Key,
idxDnaId1		1, 2, 3…Person 1, from the DNA Match view of Edit Person Window.
Links to PersonTable.PersonID.		See Change History TabY
75
DNATableID2IntegerForeign Key,
idxDnaId2		1, 2, 3…Person 2, from the DNA Match view of Edit Person Window.
Links to PersonTable.PersonID.		See Change History TabY
76
DNATableLabel1TextUser DefinedLabel 1, from the DNA Match view of Edit Person Window.
See Change History TabY
77
DNATableLabel2TextUser DefinedLabel 2, from the DNA Match view of Edit Person Window.
See Change History TabY
78
DNATableDNAProviderInteger1-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		See Change History TabY
79
DNATableSharedCMFloatUser Defined,
0-4000		Shared Centimorgans (cM), from the DNA Match view of Edit Person Window.See Change History TabY
80
DNATableSharedPercentFloatUser Defined,
0-100		Shared Percentage, from the DNA Match view of Edit Person Window.See Change History TabY
81
DNATableLargeSegFloatUser Defined,
0-500		Largest Segment (cM), from the DNA Match view of Edit Person Window.See Change History TabY
82
DNATableSharedSegsIntegerUser Defined,
0-100		Shared Segments, from the DNA Match view of Edit Person Window.See Change History TabY
83
DNATableDateTextPosition coded string or free text[See Date sheet for additional details.]See Change History TabY
84
DNATableRelate1Integer0-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. See Change History TabY
85
DNATableRelate2Integer0, 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.]		See Change History TabY
86
DNATableCommonAncIntegerForeign 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).		See Change History TabY
87
DNATable
CommonAncType
Integer0, 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).		See Change History TabY
88
DNATableVerifiedInteger0Not ImplementedSee Change History TabY
89
DNATableNoteTextUser DefinedDNA Note, from the DNA Match view of Edit Person Window.
User Interface supports line breaks and formatting tags.		See Change History TabY
90
DNATableUTCModDateFloat[d]{5}.[d]{10}
e.g.: 44993.9143704283		Coordinated Universal Time from system, modified:
SELECT julianday('now') - 2415018.5		See Change History TabY
91
EventTableEventIDIntegerPrimary Key1, 2, 3,...Event Identification Number
92
EventTableEventTypeIntegerForeign Key,
idxOwnerEvent		1, 2, 3,...Link to FactTypeID in FactTypeTable
93
EventTableOwnerTypeInteger0, 10 = Person,
1 = Family
94
EventTableOwnerIDIntegerForeign Key,
idxOwnerDate,
idxOwnerEvent		1, 2, 3,...Link based on OwnerType:
0 = PersonID in PersonTable,
1 = FamilyID in FamilyTable
95
EventTableFamilyIDIntegerForeign Key0, 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)
96
EventTablePlaceIDIntegerForeign Key0, 1, 2,...0 if no Place has been assigned to event,
else PlaceID in PlaceTable
97
EventTableSiteIDIntegerForeign Key0, 1, 2,...0 if no Place Details assigned to event,
else PlaceID (of Place Details) in PlaceTable
98
EventTableDateTextPosition coded string or free text[See Date sheet for additional details.]
99
EventTableSortDateBigIntidxOwnerDate18 digitsNumber representing a user entered date that forces an event into a position relative to other events in lists sorted on the Date field.
100
EventTableIsPrimaryInteger0, 1Primary checkbox in Edit Person Fact pane:
0 = Not checked (default),
1 = Checked. (Used to suppress from reports other conflicting facts of the same type.)