The Ancestry_Profiles table lists the A* DNA test profiles available to gather under the logged-in account. Each row is one completed test — the people you see in the kit/profile picker before you choose which kit to gather. The table is small: typically one row per test the account can administer or has been shared with.
| Column | Type | Source | Description |
|---|---|---|---|
| Id | int (PK) | Auto | Auto-incrementing primary key |
| guid | string | Profile list | The test kit GUID. Stored upper-cased and indexed; this is the key that links a profile to its matches in Ancestry_matchGroups (via testGuid). |
| name | string | Profile list | Display name for the test subject (given name + surname, or the kit’s display name) |
| treeId | string | Tree gather | The A* tree ID linked to this kit. Filled in when the user’s own tree is gathered; empty until then. |
When the client loads the list of available tests, each completed test is inserted into Ancestry_Profiles (and also mirrored into the shared DNA_Kits table). Inserts are de-duplicated on the upper-cased guid, so re-loading the profile list does not create duplicate rows. The treeId column starts empty and is updated separately once the kit’s own tree has been gathered.
testGuid = guid.