MH_Tree Table

The MH_Tree table is a lightweight registry of MyHeritage family trees. Each row is one tree, identified by its URL, and serves as the parent record that the individuals in MH_Ancestors hang off of.

Gathering status: MyHeritage gathering is currently unavailable in the Client and is expected to return in a future update. This page documents the schema as it exists for data already in your database.

Column Reference

Column	Type	Description
Id	int (PK)	Auto-incrementing primary key. Referenced by `MH_Ancestors.TreeId`.
treeurl	string	URL of the MyHeritage tree. Unique index; matches `MH_Match.tree_url`.
created_date	string	When the tree record was first created
updated_date	string	When the tree record was last updated

How It’s Populated

Rows are written by AddMH_Tree at the start of the tree gather stage, keyed on treeurl. If the tree URL already exists the existing Id is returned and reused; otherwise a new row is inserted. That Id is then used as the TreeId for every individual parsed into MH_Ancestors from that tree.

Related Tables

MH_Ancestors — the individuals belonging to this tree, linked by MH_Ancestors.TreeId = MH_Tree.Id.
MH_Match — joins on MH_Match.tree_url = MH_Tree.treeurl to connect a match to its tree.