Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| germplasm_name | VARCHAR | 255 | null |
|
|
A unique name which defines an entry in the germinatbase table. |
||
| germplasm_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
| germplasm_gid | VARCHAR | 255 | null |
|
|
A unique identifier. |
||
| germplasm_number | VARCHAR | 255 | √ | null |
|
|
This is the unique identifier for accessions within a genebank, and is assigned when a sample is |
|
| germplasm_puid | VARCHAR | 255 | √ | null |
|
|
Any persistent, unique identifier assigned to the accession so it can be unambiguously referenced at the global level and the information associated with it harvested through automated means. Report one PUID for each accession. |
|
| entity_type_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| entity_type_name | VARCHAR | 255 | √ | null |
|
|
The name of the entity type. |
|
| entity_parent_id | INT | 10 | √ | null |
|
|
Foreign key to germinatebase (germinatebase.id). |
|
| entity_parent_name | VARCHAR | 255 | √ | null |
|
|
A unique name which defines an entry in the germinatbase table. |
|
| entity_parent_general_identifier | VARCHAR | 255 | √ | null |
|
|
A unique identifier. |
|
| biological_status_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| biological_status_name | VARCHAR | 255 | √ | null |
|
|
Previoulsy known as sampstat. |
|
| synonyms | JSON | 1073741824 | √ | null |
|
|
The synonyms as a json array. |
|
| collector_number | VARCHAR | 255 | √ | null |
|
|
Original identifier assigned by the collector(s) of the sample, normally composed of the name or |
|
| genus | VARCHAR | 255 | √ |
|
|
Genus name for the species. |
||
| species | VARCHAR | 255 | √ |
|
|
Species name in lowercase. |
||
| subtaxa | VARCHAR | 255 | √ | null |
|
|
Subtaxa name. |
|
| institution_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
| institution_name | VARCHAR | 255 | √ |
|
|
The institute name. |
||
| location | VARCHAR | 255 | √ |
|
|
The site name where the location is. |
||
| latitude | DECIMAL | 64,10 | √ | null |
|
|
Latitude of the location. |
|
| longitude | DECIMAL | 64,10 | √ | null |
|
|
Longitude of the location. |
|
| elevation | DECIMAL | 64,10 | √ | null |
|
|
The elevation of the site in metres. |
|
| country_name | VARCHAR | 255 | √ |
|
|
Country name. |
||
| country_code | CHAR | 2 | √ |
|
|
ISO 2 Code for country. |
||
| coll_date | DATE | 10 | √ | null |
|
|
Collecting date of the sample, where YYYY is the year, MM is the month and DD is the day. |
|
| pdci | FLOAT | 64,10 | √ | null |
|
|
Passport Data Completeness Index. This is calculated by Germinate. Manual editing of this field will be overwritten. |
|
| image_count | BIGINT | 19 | √ | null |
|
|
||
| first_image_path | LONGTEXT | 2147483647 | √ | null |
|
|
||
| has_trials_data | INT | 10 | √ | null |
|
|
||
| has_genotypic_data | INT | 10 | √ | null |
|
|
||
| has_allelefreq_data | INT | 10 | √ | null |
|
|
||
| has_compound_data | INT | 10 | √ | null |
|
|