The DNA_Login table is the unified, cross-service registry of the accounts used to gather data. Each row represents one login at one testing company. It is the companion to DNA_Kits: kits are gathered under an account recorded here. Every service’s parser writes its login here through a single shared insert routine.
password column stores the password value associated with the login. A unique index is enforced on (company, username), so each company/username pair appears only once.| Column | Type | Description |
|---|---|---|
| Id | int (PK) | Auto-incrementing primary key. Used as the internal login reference. |
| company | string | The testing company the login is for (for example A*, FTDNA, MyHeritage, 23andMe, Gedmatch). |
| guid | string | The service’s identifier associated with the account. |
| username | string | The account username. Part of the unique key with company. |
| password | string | The password value associated with the login. |
| created_date | string | When the login row was first recorded. |
Logins are added through a single shared insert routine. Before inserting, the routine looks up an existing row by company and lower-cased username; if one already exists it returns that row’s Id rather than creating a duplicate. The returned Id ties a gather session to the account it ran under.