|
Field Name |
Type |
Key |
Notes |
|
LinkID |
INTEGER |
PRIMARY KEY |
|
|
OwnerType |
INTEGER |
|
|
|
AddressID |
INTEGER |
|
|
|
OwnerID |
INTEGER |
|
|
|
AddressNum |
INTEGER |
|
|
|
Details |
TEXT |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
AddressID |
INTEGER |
PRIMARY KEY |
|
|
AddressType |
INTEGER |
|
|
|
Name |
TEXT COLLATE RMNOCASE |
Name |
|
Street1 |
TEXT |
|
Street |
|
Street2 |
TEXT |
|
Street |
|
City |
TEXT |
|
City |
|
State |
TEXT |
|
State |
|
Zip |
TEXT |
|
Zip code |
|
Country |
TEXT |
|
Country |
|
Phone1 |
TEXT |
|
Phone |
|
Phone2 |
TEXT |
|
Phone |
|
Fax |
TEXT |
|
FAX |
|
Email |
TEXT |
|
email |
|
URL |
TEXT |
|
website URL |
|
Latitude |
INTEGER |
|
Latitude |
|
Longitude |
INTEGER |
|
Longitude |
|
Note |
BLOB |
|
|
INDEX |
idxAddressName |
Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
RecID |
INTEGER |
PRIMARY KEY |
|
|
ChildID |
INTEGER |
|
|
|
FamilyID |
INTEGER |
|
Family ID# |
|
RelFather |
INTEGER |
|
|
|
RelMother |
INTEGER |
|
|
|
ChildOrder |
INTEGER |
|
|
|
IsPrivate |
INTEGER |
|
|
|
ProofFather |
INTEGER |
|
|
|
ProofMother |
INTEGER |
|
|
|
Note |
BLOB |
|
|
INDEX |
idxChildFamilyID |
FamilyID |
|
|
INDEX |
idxChildID |
ChildID |
|
|
INDEX |
idxChildOrder |
ChildOrder |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
CitationID |
INTEGER |
PRIMARY KEY |
|
|
OwnerType |
INTEGER |
|
|
|
SourceID |
INTEGER |
|
|
|
OwnerID |
INTEGER |
|
|
|
Quality |
TEXT |
|
|
|
IsPrivate |
INTEGER |
|
|
|
Comments |
BLOB |
|
|
|
ActualText |
BLOB |
|
|
|
RefNumber |
TEXT |
|
|
|
Flags |
INTEGER |
|
|
|
Fields |
BLOB |
|
|
INDEX |
idxCitationOwnerID |
OwnerID |
|
|
INDEX |
idxCitationSourceID |
SourceID |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
RecID |
INTEGER |
PRIMARY KEY |
|
|
RecType |
INTEGER |
|
|
|
Title |
TEXT |
|
|
|
DataRec |
BLOB |
|
|
INDEX |
idxRecType |
RecType |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
EventID |
INTEGER |
PRIMARY KEY |
|
|
EventType |
INTEGER |
|
(See Fact/Event Types) |
|
OwnerType |
INTEGER |
|
0 = individual; 1 = family |
|
OwnerID |
INTEGER |
|
|
|
FamilyID |
INTEGER |
|
|
|
PlaceID |
INTEGER |
|
Place ID# |
|
SiteID |
INTEGER |
|
|
|
Date |
TEXT |
|
|
|
SortDate |
INTEGER |
|
|
|
IsPrimary |
INTEGER |
|
|
|
IsPrivate |
INTEGER |
|
|
|
Proof |
INTEGER |
|
|
|
Status |
INTEGER |
|
|
|
EditDate |
FLOAT |
|
|
|
Sentence |
BLOB |
|
|
|
Details |
BLOB |
|
|
|
Note |
BLOB |
|
|
INDEX |
idxOwnerDate |
OwnerID, SortDate |
|
INDEX |
idxOwnerEvent |
OwnerID, EventType |
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
RecID |
INTEGER |
PRIMARY KEY |
|
|
ExclusionType |
INTEGER |
|
|
|
ID1 |
INTEGER |
|
|
|
ID2 |
INTEGER |
|
|
UNIQUE INDEX |
idxExclusionIndex |
ExclusionType, ID1, ID2 |
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
FactTypeID |
INTEGER |
PRIMARY KEY |
ID number of fact (user-defined facts above 1000) |
|
OwnerType |
INTEGER |
|
0 = individual; 1 = family |
|
Name |
TEXT COLLATE RMNOCASE |
Fact name |
|
Abbrev |
TEXT |
|
Fact abbreviation |
|
GedcomTag |
TEXT |
|
Gedcom Tag |
|
UseValue |
INTEGER |
|
1 = use value field |
|
UseDate |
INTEGER |
|
1 = use date field |
|
UsePlace |
INTEGER |
|
1 = use place field |
|
Sentence |
BLOB |
|
Sentence definition |
|
Flags |
INTEGER |
|
|
INDEX |
idxFactTypeAbbrev |
Abbrev |
|
|
INDEX |
idxFactTypeGedcomTag |
GedcomTag |
|
|
INDEX |
idxFactTypeName |
Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
FamilyID |
INTEGER |
PRIMARY KEY |
Family ID# |
|
FatherID |
INTEGER |
|
Person ID# |
|
MotherID |
INTEGER |
|
Person ID# |
|
ChildID |
INTEGER |
|
|
|
HusbOrder |
INTEGER |
|
|
|
WifeOrder |
INTEGER |
|
|
|
IsPrivate |
INTEGER |
|
|
|
Proof |
INTEGER |
|
|
|
SpouseLabel |
INTEGER |
|
|
|
FatherLabel |
INTEGER |
|
|
|
MotherLabel |
INTEGER |
|
|
|
Note |
BLOB |
|
|
INDEX |
idxFamilyFatherID |
FatherID |
|
|
INDEX |
idxFamilyMotherID |
MotherID |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
RecID |
INTEGER |
PRIMARY KEY |
|
|
GroupID |
INTEGER |
|
|
|
StartID |
INTEGER |
|
|
|
EndID |
INTEGER |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
LabelID |
INTEGER |
PRIMARY KEY |
|
|
LabelType |
INTEGER |
|
|
|
LabelValue |
INTEGER |
|
|
|
LabelName |
TEXT COLLATE RMNOCASE |
|
|
Description |
TEXT |
|
|
INDEX |
idxLabelType |
LabelType |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
LinkID |
INTEGER |
PRIMARY KEY |
|
|
extSystem |
INTEGER |
|
|
|
LinkType |
INTEGER |
|
|
|
rmID |
INTEGER |
|
|
|
extID |
TEXT |
|
|
|
Modified |
INTEGER |
|
|
|
extVersion |
TEXT |
|
|
|
extDate |
FLOAT |
|
|
|
Status |
INTEGER |
|
|
|
Note |
BLOB |
|
|
INDEX |
idxLinkExtId |
extID |
|
|
INDEX |
idxLinkRmId |
rmID |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
LinkID |
INTEGER |
PRIMARY KEY |
|
|
MediaID |
INTEGER |
|
|
|
OwnerType |
INTEGER |
|
|
|
OwnerID |
INTEGER |
|
|
|
IsPrimary |
INTEGER |
|
|
|
Include1 |
INTEGER |
|
|
|
Include2 |
INTEGER |
|
|
|
Include3 |
INTEGER |
|
|
|
Include4 |
INTEGER |
|
|
|
SortOrder |
INTEGER |
|
|
|
RectLeft |
INTEGER |
|
|
|
RectTop |
INTEGER |
|
|
|
RectRight |
INTEGER |
|
|
|
RectBottom |
INTEGER |
|
|
|
Note |
TEXT |
|
|
|
Caption |
TEXT COLLATE RMNOCASE |
|
|
RefNumber |
TEXT COLLATE RMNOCASE |
|
|
Date |
TEXT |
|
|
|
SortDate |
INTEGER |
|
|
|
Description |
BLOB |
|
|
INDEX |
idxMediaOwnerID |
OwnerID |
|
|
INDEX |
idxMediaCaption |
Caption |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
MediaID |
INTEGER |
PRIMARY KEY |
|
|
MediaType |
INTEGER |
|
|
|
MediaPath |
TEXT |
|
|
|
MediaFile |
TEXT COLLATE RMNOCASE |
|
|
URL |
TEXT |
|
|
|
Thumbnail |
BLOB |
|
|
INDEX |
idxMediaFile |
MediaFile |
|
|
INDEX |
idxMediaURL |
URL |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
NameID |
INTEGER |
PRIMARY KEY |
Person ID# |
|
OwnerID |
INTEGER |
|
|
|
Surname |
TEXT COLLATE RMNOCASE |
Surname |
|
Given |
TEXT COLLATE RMNOCASE |
Given name |
|
Prefix |
TEXT COLLATE RMNOCASE |
Prefix |
|
Suffix |
TEXT COLLATE RMNOCASE |
Suffix |
|
Nickname |
TEXT COLLATE RMNOCASE |
Nickname |
|
NameType |
INTEGER |
|
|
|
Date |
TEXT |
|
|
|
SortDate |
INTEGER |
|
|
|
IsPrimary |
INTEGER |
|
|
|
IsPrivate |
INTEGER |
|
|
|
Proof |
INTEGER |
|
|
|
EditDate |
FLOAT |
|
|
|
Sentence |
BLOB |
|
|
|
Note |
BLOB |
|
|
|
BirthYear |
INTEGER |
|
|
|
DeathYear |
INTEGER |
|
|
INDEX |
idxSurname |
Surname |
|
|
INDEX |
idxSurnameGiven |
Surname, Given, BirthYear, DeathYear |
|
INDEX |
idxNameOwnerID |
OwnerID |
|
|
INDEX |
idxNamePrimary |
IsPrimary |
|
|
INDEX |
idxGiven |
Given |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
PersonID |
INTEGER |
PRIMARY KEY |
|
|
UniqueID |
TEXT |
|
|
|
Sex |
INTEGER |
|
|
|
EditDate |
FLOAT |
|
|
|
ParentID |
INTEGER |
|
|
|
SpouseID |
INTEGER |
|
|
|
Color |
INTEGER |
|
|
|
Relate1 |
INTEGER |
|
|
|
Relate2 |
INTEGER |
|
|
|
Flags |
INTEGER |
|
|
|
Living |
INTEGER |
|
|
|
IsPrivate |
INTEGER |
|
|
|
Proof |
INTEGER |
|
|
|
Bookmark |
INTEGER |
|
|
|
Note |
BLOB |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
PlaceID |
INTEGER |
PRIMARY KEY |
|
|
PlaceType |
INTEGER |
|
|
|
Name |
TEXT COLLATE RMNOCASE |
|
|
Abbrev |
TEXT |
|
|
|
Normalized |
TEXT |
|
|
|
Latitude |
INTEGER |
|
|
|
Longitude |
INTEGER |
|
|
|
LatLongExact |
INTEGER |
|
|
|
MasterID |
INTEGER |
|
|
|
Note |
BLOB |
|
|
INDEX |
idxPlaceAbbrev |
Abbrev |
|
|
INDEX |
idxPlaceName |
Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
TaskID |
INTEGER |
PRIMARY KEY |
|
|
TaskType |
INTEGER |
|
|
|
OwnerID |
INTEGER |
|
|
|
OwnerType |
INTEGER |
|
|
|
RefNumber |
TEXT |
|
|
|
Name |
TEXT COLLATE RMNOCASE |
|
|
Status |
INTEGER |
|
|
|
Priority |
INTEGER |
|
|
|
Date1 |
TEXT |
|
|
|
Date2 |
TEXT |
|
|
|
Date3 |
TEXT |
|
|
|
SortDate1 |
INTEGER |
|
|
|
SortDate2 |
INTEGER |
|
|
|
SortDate3 |
INTEGER |
|
|
|
Filename |
TEXT |
|
|
|
Details |
BLOB |
|
|
INDEX |
idxResearchName |
Name |
|
|
INDEX |
idxResearchOwnerID |
OwnerID |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
RoleID |
INTEGER |
PRIMARY KEY |
|
|
RoleName |
TEXT COLLATE RMNOCASE |
|
|
EventType |
INTEGER |
|
|
|
RoleType |
INTEGER |
|
|
|
Sentence |
TEXT |
|
|
INDEX |
idxRoleEventType |
EventType |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
SourceID |
INTEGER |
PRIMARY KEY |
|
|
Name |
TEXT COLLATE RMNOCASE |
|
|
RefNumber |
TEXT |
|
|
|
ActualText |
TEXT |
|
|
|
Comments |
TEXT |
|
|
|
IsPrivate |
INTEGER |
|
|
|
TemplateID |
INTEGER |
|
|
|
Fields |
BLOB |
|
|
INDEX |
idxSourceName |
Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
TemplateID |
INTEGER |
PRIMARY KEY |
|
|
Name |
TEXT COLLATE RMNOCASE |
|
|
Description |
TEXT |
|
|
|
Favorite |
INTEGER |
|
|
|
Category |
TEXT |
|
|
|
Footnote |
TEXT |
|
|
|
ShortFootnote |
TEXT |
|
|
|
Bibliography |
TEXT |
|
|
|
FieldDefs |
BLOB |
|
|
INDEX |
idxSourceTemplateName |
Name |
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Type |
Key |
Notes |
|
WitnessID |
INTEGER |
PRIMARY KEY |
|
|
EventID |
INTEGER |
|
|
|
PersonID |
INTEGER |
|
|
|
WitnessOrder |
INTEGER |
|
|
|
Role |
INTEGER |
|
|
|
Sentence |
TEXT |
|
|
|
Note |
BLOB |
|
|
|
Given |
TEXT COLLATE RMNOCASE |
|
|
Surname |
TEXT COLLATE RMNOCASE |
|
|
Prefix |
TEXT COLLATE RMNOCASE |
|
|
Suffix |
TEXT COLLATE RMNOCASE |
|
INDEX |
idxWitnessEventID |
EventID |
|
|
INDEX |
idxWitnessPersonID |
PersonID |
|
|