HelpDatabase Reference › Ancestry_Kit

Ancestry_Kit Table

The Ancestry_Kit table holds the A* sign-in record used by the client to reach an account’s test profiles. It is a small, internal bookkeeping table — one row per stored login — not a store of DNA matches.

Internal app data: This table is application housekeeping, not match data. It is also a legacy table that is being superseded by the shared DNA_Kits table.

Column Reference

ColumnTypeSourceDescription
Idint (PK)AutoAuto-incrementing primary key
kitnumberstringAppKit number for the login. Not set by the current login flow.
usernamestringAppThe A* account username used to sign in
passwordstringAppInternal credential storage for the login. The current login flow writes an empty value here.
created_datestringAppDate the row was created (MM/dd/yyyy)
syncstringAppSync status flag (set to “0” on insert)
loginUsernamestringAppThe DNAGedcom username that owns this record

How It’s Populated

A row is added after a successful A* sign-in. Inserts are de-duplicated on the username/password pair, so signing in again with the same credentials does not create a duplicate row. The loginUsername and sync fields are stamped by the client at insert time.

Related Tables

  • Ancestry_Profiles — the test profiles reachable under this login.
  • DNA_Kits — the shared, cross-service kit table that is replacing this per-service table.