Database Reference

This section provides detailed documentation for each database table in the DNAGedcom Client. It covers column definitions, data sources, how fields are populated during gathering, and data preservation rules.

A* Tables

Table	Description
Ancestry_matchGroups	Primary match table. DNA match data, relationship predictions, shared cM, parent side, metadata.
Ancestry_MatchProfile	Per-match profile data — match name, managing tester name, photo, and gender — keyed on matchGuid. Names moved here from Ancestry_matchGroups in the 2026-04-30 A* update.
Ancestry_matchDetail	Supplemental per-match detail: shared-segment count, member-since year, and administrator UCDM id.
Ancestry_RelationshipPredictions	Detailed relationship predictions with ranked probabilities per match.
Ancestry_ICW	In Common With (shared match) relationships.
Ancestry_matchTrees	Family tree individuals linked to matches.
Ancestry_TreeData	Tree metadata (tree ID, size, privacy status).
AncestryAncestorCouple	Common ancestor couples shared between matches.
Ancestry_SharedBirthLocations	Shared ancestral birth locations between the test and a match, with sample/match person counts.
Ancestry_SharedJourneys	Shared A* migration “journeys” between the test and a match.
Ancestry_MatchEthnicityRegion	Per-match ethnicity estimate — region key and percentage for each match.
Ancestry_EthnicityRegion	Ethnicity region lookup: region key → display name and parent (macro) region.
Ancestry_Ethnicity	Legacy ethnicity code/value lookup.
Ancestry_Locations	Birth and death locations from match trees.
Ancestry_Profiles	DNA test profiles and kit information.
Ancestry_Kit	Stored A* account/kit login credentials (internal).

FTDNA Tables

Table	Description
FTDNA_Matches2	Primary Family Finder match table: match identity and names, contact, relationship range, total and longest shared cM, Y-DNA/mtDNA markers and haplogroups, and tree URLs.
FTDNA_ICW2	In-Common-With (shared match) pairs between two of your matches.
FTDNA_Chromo2	Chromosome-browser segment data (chromosome, start/end position, cM, SNPs) per match.
FTDNA_Tree	Family tree individuals from matches’ linked trees: person details, parents, haplogroups, and pedigree links.
FTDNA_Kit	Stored FTDNA account/kit login credentials (internal).

23andMe Tables

23andMe tables use the MeAnd23W_ prefix and are keyed per profile by psid (the 23andMe profile ID).

Table	Description
MeAnd23W_Kit	Stored 23andMe account/kit login credentials (internal).
MeAnd23W_Profiles	23andMe profiles available under the account (profile id, name, source).
MeAnd23W_Relatives	DNA Relatives list — comprehensive per-relative data: names, predicted relationship and range, shared DNA and segments, haplogroups, ancestry composition, locations, and sharing/contact status.
MeAnd23W_Matches	Match records gathered for a profile (relative identity, relationship, shared DNA, haplogroups).
MeAnd23W_ICW	In-Common-With pairs with shared cM and percent shared.
MeAnd23W_Triag	Triangulation flags between two relatives for a profile.
MeAnd23W_FIANew	Shared DNA segments (Family Inheritance: Advanced): chromosome, start/end, genetic distance, SNPs.
MeAnd23W_FamilyTree	23andMe family tree nodes: relationships, parents/partners, generations, and flags.
MeAnd23W_Shares	Shared/connected datasets for a profile (guid, name, source).
MeAnd23W_Haplo	Haplogroup sharing between you and a relative.
MeAnd23W_AncestryCompSummary	Ancestry Composition summary: population percentages by threshold.
MeAnd23W_AncestryCompSegments	Ancestry Composition painted chromosome segments per population.

MyHeritage Tables

Table	Description
MH_Match	Primary match table: identity, estimated relationship, shared cM/segments, tree info, surnames, and per-step gather dates.
MH_ICW	In-Common-With pairs with shared cM, percent, and triangulation totals.
MH_Chromo	Shared chromosome segments between two kits (chromosome, cM, start/end, SNPs).
MH_Triangulate	Triangulated segments among a kit and two matches.
MH_Tree	Match tree references (tree URL, created/updated dates).
MH_Ancestors	Tree individuals (ancestors) from match trees.

GEDmatch Tables

Table	Description
GM_Kit	Kit registry: kit number, name, sex, haplogroups, and WikiTree linkage.
GM_Match	One-to-one match list between two kits (shared/largest cM, generations, run dates).
GM_Segment	Shared chromosome segments between two kits.
GM_ICW	In-Common-With pairs with total shared cM.
GM_TriangulatedSegment	AutoSegment triangulated clusters — overlapping segments on a chromosome shared by multiple matches.
GM_CommonAncestor	Common ancestors identified from match trees (from ClusterDisplay data).
GM_CommonLocation	Locations shared across match trees.

DNAGedcom Tree

The unified, service-independent family-tree store. GEDCOM uploads and gathered match trees are normalized into these tables so the People and Common Ancestor tools can compare trees across services.

Table	Description
DGTree	Tree records: name, tree id/URL, base person, source, and the linked match (if any).
DGIndividual	Individuals within a tree: names, dates, places, parents/spouse, and ahnentafel relationship id.

Shared & Core Tables

Cross-service and internal application tables that are not tied to a single testing company.

Table	Description
DNA_Kits	Unified kit registry across all services (company, guid, name, role).
DNA_KitSummary	Per-kit summary counts (matches, ICW, chromosomes, surnames, ancestors, trees).
DNA_Login	Cross-service login credentials (internal).
DNA_Tag	User tags/labels applied to tests or matches.
DNA_Process	Record of each gather run (parameters, results, options gathered, cM range).
DNA_Schedule	Scheduled recurring gathers (internal).
Gather_History	History of gather requests with timing and cM metrics.
Settings	Application key/value settings (internal).
Kit_TreeAssignment	Assigns a tree (GEDCOM or a service tree) to a DNA kit.
Match_TreeOverride	Overrides a match’s gathered tree with a better tree (e.g., a GEDCOM upload).
Computed_CommonAncestors	Cached common-ancestor results from pairwise tree comparison.
Computed_AncestorStatus	Per-kit common-ancestor computation status (last run, counts).