Formal Database Structure

Introduction

Family Historian (ƒh) uses the GEDCOM data structure for its records, which is similar to many other genealogy products.

Details

Data is stored using the following main record types:

  • Individual Records ~ Hold facts about each person such as Name, Birth & Death
  • Family Records ~ Hold parent child relationships and family facts such as Marriage
  • Note Records ~ Hold general notes that may be shared by multiple records
  • Source Records ~ Hold source document details cited by the facts
  • Repository Records ~ Hold details of source document repositories
  • Multimedia Records ~ Hold details of external media files such as photos and documents
  • Place Records ~ Hold place name details such as latitude & longitude (only in ƒh V6 or later)
  • Research Note Records ~ Hold research notes linked to one or more records (only in ƒh V7 or later)
  • Address Records ~ Hold addresses, each normally linked to a Place record (only in ƒh V8 or later)

These all inter-relate by using data fields to link the records together. The diagram below shows some of the ways which records can be linked together to store your family history information.

Database structure in Family Historian 7 and 8
Database structure in Family Historian 7 and 8. Address records are new in Version 8.

Facts are included on the diagram although they are not actually held as records in their own right. Citations are also not records in their own right, but are used to connect many of the other records to Sources, so are included to make the relationships clearer.

The diagram shows the main links and a sample of the rest. The table lists every link each record type can hold. A link is made from the record in the first column to the records in the second; the third column has anything that changed in Version 8.

From Links to Version 8
Individual Family (as spouse or parent, and as child); its own Facts; Citations; Multimedia; Note; Research Note Non-family relationships between Individuals (friends, groups, custom relationships)
Family Individual (husband, wife, children); its own Facts; Citations; Multimedia; Note; Research Note
Facts (held inside Individual and Family records) Citations; Place (by name); Multimedia; Individual (as a witness) Address
Citation (held inside records and facts) Source; Multimedia
Source Repository; Source Template (templated sources, Version 7 on); Multimedia; Note; Research Note Free-form sources: a third kind of source alongside generic and templated
Repository Note; Research Note
Source Template Nothing; it is linked to from Source records
Multimedia Citations; Research Note
Note Citations; Research Note
Place Multimedia; Research Note Address records link to a Place
Address — New record type: Place; Multimedia; Research Note
Research Note Any record, as an embedded link in the note text

Note records and Research Notes differ in what can point at them. Note records can be linked from Individual, Family, Source and Repository records but not from Places, Addresses, facts or citations, which have local notes instead. Research Notes can be linked from the top level of any record, Places and Addresses included.

Note Records are linked to other records where local Note fields are allowed.

Place Records were introduced in ƒh V6, and are linked to each Place field by Name rather than Record Id.

Research Note Records were introduced in ƒh V7 to hold family history research details, and are linked to the top level of other records.

Source Template Records were introduced in ƒh V7 to hold formatting details for templated Source records.

Address Records were introduced in ƒh V8. An address that used to be free text on an event is now a record in its own right, linked to a Place Record, and can be geocoded and mapped like a place.

In addition there are Header Record, Submitter Record and Submission Record types.

The last two pages of the GEDCOM Standard Release 5.5 specification has a GEDCOM 5.5 DATA MODEL CHART that illustrates the full data structure, which is formally defined within the linear-linked grammar on the earlier pages. ƒh is based on that data model but with allowed customisations as defined by the GEDCOM Extension List and in ƒh V7 is modified for the GEDCOM Standard Release 5.5.1 specification.

Last update: 2026-09-23 11:19:37