The DNA_Process table records individual gather runs. Each row captures one run for one kit — when it started and finished, what it was asked to do, what it produced, which optional passes it included, and the cM thresholds it used. It provides a per-run history keyed to the kit it ran against.
(dk_id, start_time), so a kit’s runs can be looked up and ordered by start time.| Column | Type | Description |
|---|---|---|
| Id | int (PK) | Auto-incrementing primary key. |
| dk_id | int | The kit this run was for — the Id of the corresponding DNA_Kits row. |
| start_time | DateTime | When the run started. |
| end_time | DateTime | When the run finished. |
| parameters | string | The parameters the run was started with. |
| results | string | A record of what the run produced. |
| ranICW | bool | True if the run included an in-common-with (shared match) pass. |
| ranTree | bool | True if the run included a tree-gathering pass. |
| ranChromosome | bool | True if the run included a chromosome/segment pass. |
| mincM | decimal | The minimum centimorgan threshold the run was configured with. |
| maxcM | decimal | The maximum centimorgan threshold the run was configured with. |
| finishcM | decimal | The centimorgan value the run reached when it finished. |
| dg_version | string | The DNAGedcom Client version that performed the run. |
dk_id references a kit’s Id.