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. |
|
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. |
|
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 | 26 | √ | null |
|
|
When the record was created. |