HelpDatabase Reference › MeAnd23W_Triag

MeAnd23W_Triag Table

The MeAnd23W_Triag table records triangulation results for 23andMe. A row marks whether two relatives, id1 and id2, triangulate — that is, whether they share an overlapping DNA segment with each other — for the gathered profile psid. When three people all share DNA over the same segment region, that segment most likely comes from a common ancestor, which makes triangulation a useful confirmation tool.

Reserved table: This table is defined and indexed in the database (on psid, id1, id2), and the client includes an insert routine for it, but it is not part of the standard 23andMe gather flow today. Treat it as a reserved / future-use structure: it may be empty in many databases.

Column Reference

ColumnTypeDescription
Idint (PK)Auto-incrementing primary key
psidstringThe 23andMe profile ID being gathered — the perspective from which the triangulation is evaluated
id1string23andMe profile ID of the first relative in the pair
id2string23andMe profile ID of the second relative in the pair
triagboolTriangulation flag — true if id1 and id2 triangulate (share an overlapping segment) for the profile psid, false if they do not
Deduplication: Before inserting, the application checks for an existing row with the same psid, id1, and id2; if one already exists, the new row is skipped.

Related Tables

  • MeAnd23W_FIANew — the shared DNA segments whose overlap determines whether two relatives triangulate.
  • MeAnd23W_ICW — In Common With pairs; triangulation is the segment-level confirmation that two in-common people share the same region.
  • MeAnd23W_Relatives — the relative list whose psid and ehid profile IDs correspond to psid, id1, and id2 here.