The Ancestry_SharedJourneys table records the migration “journeys” — A*’s genetic-community paths — that a test kit shares with a match. Each row is one journey shared between your kit and one match. A pair can share several journeys, so a single match may contribute several rows.
| Column | Type | Source | Description |
|---|---|---|---|
| Id | int (PK) | Auto | Auto-incrementing primary key |
| testGuid | string | Match Compare | The test kit GUID (your kit, stored uppercase) |
| matchGuid | string | Match Compare | The matched person’s GUID (stored uppercase) |
| journeyId | string | Match Compare | A*’s identifier for the shared journey / genetic community |
| displayName | string | Match Compare | Human-readable journey name |
| created_date | string | App | Date the row was captured (yyyy-MM-dd) |
(testGuid, matchGuid, journeyId) keeps a shared journey from being duplicated. Re-gathering upserts each journey rather than adding a second copy.This data is captured from the shared-journeys response on a match’s compare page, so it is only gathered when tree or ICW gathering is enabled. Each journey returned for the pair is upserted into the table.
matchGuid.