Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| parent_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| parent_gid | VARCHAR | 255 | √ | null |
|
|
A unique identifier. |
|
| parent_name | VARCHAR | 255 | √ | null |
|
|
A unique name which defines an entry in the germinatbase table. |
|
| parent_display_name | VARCHAR | 255 | √ | null |
|
|
The name to be displayed on user interfaces and to be exported to external tools like Flapjack and Helium. |
|
| parent_number | VARCHAR | 255 | √ | null |
|
|
This is the unique identifier for accessions within a genebank, and is assigned when a sample is entered into the genebank collection (e.g. ‘PI 113869’). |
|
| child_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| child_gid | VARCHAR | 255 | √ | null |
|
|
A unique identifier. |
|
| child_name | VARCHAR | 255 | √ | null |
|
|
A unique name which defines an entry in the germinatbase table. |
|
| child_display_name | VARCHAR | 255 | √ | null |
|
|
The name to be displayed on user interfaces and to be exported to external tools like Flapjack and Helium. |
|
| child_number | VARCHAR | 255 | √ | null |
|
|
This is the unique identifier for accessions within a genebank, and is assigned when a sample is entered into the genebank collection (e.g. ‘PI 113869’). |
|
| dataset_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| dataset_name | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the dataset. |
|
| experiment_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| experiment_name | VARCHAR | 255 | √ | null |
|
|
The name of the experiment. |
|
| relationship_type | enum('M', 'F', 'OTHER') | 5 | OTHER |
|
|
Male or Female parent. Should be recorded as ‘M’ (male) or ‘F’ (female). |
||
| relationship_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
Can be used as a meta-data field to describe the relationships if a complex rellationship is required. Examples may include, ‘is a complex cross containing’, ‘F4 generation’ and so on. This is used by the Helium pedigree visualiztion tool. |
|
| pedigree_description | VARCHAR | 255 | √ | null |
|
|
The name of the pedigree. |
|
| VARCHAR | 255 | √ | null |
|
|
Who is responsible for the creation of the pedigree. Attribution should be included in here for pedigree sources. |