Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| germplasm_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| germplasm_name | VARCHAR | 255 | √ | null |
|
|
A unique name which defines an entry in the germinatbase table. |
|
| germplasm_display_name | VARCHAR | 255 | √ | null |
|
|
The name to be displayed on user interfaces and to be exported to external tools like Flapjack and Helium. |
|
| pedigree_notation_name | VARCHAR | 255 | √ | null |
|
|
Name of the reference notation source. |
|
| pedigree_notation_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
A longer description about the reference notation source. |
|
| pedigree_notation_url | VARCHAR | 255 | √ | null |
|
|
Hyperlink to the notation source. |
|
| dataset_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| dataset_name | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the dataset. |
|
| definition_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| definition | MEDIUMTEXT | 16777215 | null |
|
|
The pedigree string which is used to represent the germinatebase entry. |
||
| pedigree_description_name | VARCHAR | 255 | √ | null |
|
|
The name of the pedigree. |
|
| pedigree_description_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the pedigree in more detail. |
|
| VARCHAR | 255 | √ | null |
|
|
Who is responsible for the creation of the pedigree. Attribution should be included in here for pedigree sources. |
||
| created_on | DATETIME | 19 | √ | CURRENT_TIMESTAMP |
|
|
When the record was created. |