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. |
|
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. |
|
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. |