The Kit_TreeAssignment table assigns a tree to a DNA kit. It establishes “my tree” for a kit — the tree that the kit’s matches are compared against when computing common ancestors. The assigned tree can come from a GEDCOM upload, a tree gathered from a service, or another kit’s gathered trees (cross-service sharing).
KitGuid.| Column | Type | Description |
|---|---|---|
| Id | int (PK) | Auto-incrementing primary key |
| KitGuid | string | The DNA kit this tree is assigned to |
| Company | string | Which service the kit belongs to (Ancestry, FTDNA, MyHeritage, GEDMatch) |
| TreeSource | string | Where the tree data lives: GEDCOM, Ancestry, FTDNA, MH |
| TreeId | int | DGTree.Id for GEDCOM/FTDNA trees, or -1 for gathered kit match trees |
| SourceKitGuid | string | For cross-service sharing: the kit whose gathered trees to use (nullable) |
| AssignDate | DateTime | When the assignment was made (UTC) |
| Notes | string | Optional free-text notes about the assignment (nullable) |
When a user assigns a tree to a kit, the application deletes any prior assignment for that KitGuid and inserts a new row with AssignDate set to the current UTC time. When TreeId points to a DGTree record, the assigned tree is a GEDCOM upload or gathered service tree; when TreeId is -1 and SourceKitGuid is set, the kit reuses another kit’s gathered match trees.
TreeId (GEDCOM uploads and gathered trees).