FTDNA_Kit Table

The FTDNA_Kit table holds the FTDNA kit and credential records the application uses internally to connect to and gather from FTDNA. It is not match data — it is the set of kits known to the app and the sign-in details associated with them.

Internal app data: This table stores internal application data, not DNA match results. The password column is internal credential storage used by the app to authenticate with FTDNA; it is part of the app’s own bookkeeping rather than gathered match data.

Column Reference

Column	Type	Description
Id	int (PK)	Auto-incrementing primary key
loginUsername	string	The DNAGedcom username this kit record belongs to
kitnumber	string	The FTDNA kit number
username	string	The FTDNA account username/login
password	string	Internal credential storage for the FTDNA account, used by the app to sign in
created_date	string	When the kit record was created
sync	string	Sync status flag (set to “0” when a new record is added)

Related Tables

FTDNA_Matches2 — the match list gathered for a kit.
FTDNA_ICW2 — In Common With (shared matches) for FTDNA kits.
FTDNA_Chromo2 — shared chromosome-browser segments between two FTDNA kits.
FTDNA_Tree — family-tree individuals from matches’ linked trees.