XY Family Tree Data Structure
XY Family Tree is based on sound principles of "normalised" data, which means there should be no chance of conflicting information. Below is the structure of XY Family Tree, given as tables and fields, and explanations of each.
- Person - about a Person
- Marriage - about the link between two Persons in a recognised agreement
- Association - similar to Marriage but without a recognised agreement
- Source - an image, document or any other file on a PC that is of interest
- LinkPersonSource - a table linking a Person to a Source
Data Relationships - relationships between the tables
Why no Events as in GEDCOM? Events themselves are of no interest in genealogy unless they have relevance to individuals. An Event may be a gathering - show any evidence of this as a Source (document, certificate, image, sound or video); an Event may be an event - again, show any evidence of this as a Source (document, image, sound or video). Simply, a Source contains information that is relevant to people.
Why no Families as in GEDCOM? Children are not always born into a family. Sometimes they are but it's not always the case. What is always true is that a child has a single mother and a single father.
- ID of Person - A unique number for a person only within each family file
- Level of Hide - Indicates where to show or hide this person
- Surname Born - The family name, the one generally used
- Other Surname - Other family names used - deprecated, show this in notes
- Forenames - The usual given names
- Place of Birth - If known - helps a little on the display on screen
- Sex - Male, Female or Unknown - no other options
- Date of Birth - In any format but the format needs to be the same for all
- Year of Birth - The year is a best-guess to help sort people in sequence
- Date of Death - In any format but the format needs to be the same for all
- ID of Father - If known - see note 1
- ID of Mother - If known - see note 1
- Place of Death - Useful for display but not essential here
- Brief Note - Any brief note can be used on the XY website
- Notes - Everything else you'd like to include about a person
- Private Notes - Notes only for your eyes
- UUID - Assigned by XY if there isn't already a unique identifier
- Last Modified - When the record was last changed
Although it would be possible to add many more fields to that list it really isn't necessary. You can add your own fields simply in the Notes. For instance if you would like a field Graduation Date simply include Graduation Date: 5th September 2012 in the notes and just use the search facility to see all people with a Graduation Date. Similarly Occupation or any of the multitude of other tags available in GEDCOM. You have the power to make this work the way you would like and exchange it with other people.
Especially important is that "Year of Birth" is entirely down to your best guess. This enables sorting people into a chronological sequence even if you don't know exact dates. It only needs to be understood that "Year of Birth" is used for this purpose. Actual "Date of Birth" can be complete or partial or missing.
- Marriage ID - A unique number for a marriage only within each family file
- Male ID - The ID of the male Person in the Marriage
- Female ID - The ID of the female Person in the Marriage
- Date of Marriage - If known
- End of Marriage - Seldom known or used
- Notes - As much as you like
- Association ID - A unique number for an association only within each family file
- Left ID - The ID of one Person in a relationship
- Right ID - The ID of one Person in a relationship
- Date of Relationship - If known - not important
- End of Relationship - If known - not important
- Left Notes - Notes about one person in the relationship
- Right Notes - Notes about the other person in the relationship
- ID - A unique number for a source only within each family file
- Source Path - Where the file may be found by your PC
- Text - Notes about the Source
- Person ID - The ID of a Person linked to a Source
- Source ID - The ID of the Source to whom that Person is linked
- Comment - About the Person in connection with the Source
If neither parent is known it's impossible to know any earlier connection. Any connection between a child and grandparent must involve at least one person in between.
If neither parent is known it's impossible to connect siblings. If children are known to be siblings they must share at least one parent. An unknown person will be created as this parent if necessary. Details can follow if discovered.
In the views below MetaData is data that tells more about the basic data. The basic data might be that a person with ID=99 is the son of people whose IDs are 66 and 77. The MetaData could show that person with ID=99 was named John Smith, born in 1901 and died in 1999, was an army Major who served WW2 and later went on to do good things for the community. Marriages, Associations and Sources can also have MetaData.
People and Sources
You can get your free copy from the download page.
XY Family Tree © 2005 - 2017