The MH_Ancestors table stores the individual people found in MyHeritage family trees. Each row is one person in a tree, with their name, life dates, parents, and a link back to the match the tree was gathered for.
| Column | Type | Description |
|---|---|---|
| Id | int (PK) | Auto-incrementing primary key |
| TreeId | int | The MH_Tree.Id of the tree this person belongs to. Indexed. |
| matchid | string | The MyHeritage member ID this individual is associated with. Indexed; ties tree people back to a match. |
| surname | string | Last name |
| given | string | First/given name |
| birthdate | string | Birth date |
| deathdate | string | Death date |
| birthplace | string | Birth place. Not populated by the current gather code; stored as an empty string. |
| deathplace | string | Death place. Not populated by the current gather code; stored as an empty string. |
| relid | string | Ahnentafel/relationship number within the tree. Not populated by the current gather code; stored as an empty string. |
| personId | string | This person’s unique ID within the tree |
| fatherId | string | personId of this person’s father within the same tree |
| motherId | string | personId of this person’s mother within the same tree |
| gender | string | This person’s gender |
| dnaLink | string | Link to this person’s DNA matches, when the tree exposes one |
personId, fatherId, and motherId — a person’s parents are the rows whose personId equals this row’s fatherId and motherId within the same TreeId.Rows are written by AddMH_Ancestors during the tree gather stage. After AddMH_Tree registers the tree and returns its Id, each person in the tree’s person list is stored with that TreeId, name, dates, parent IDs, gender, member ID (matchid), and DNA link. Inserts are de-duplicated on the combination of TreeId and personId. The birthplace, deathplace, and relid columns are set to empty strings by the current code.
TreeId = MH_Tree.Id.MH_Tree (and via matchid) to connect tree individuals to a DNA match.