Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| germinatebase_id | INT | 10 | null |
|
|
||||||
| puid | TEXT | 65535 | √ | 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. |
||||
| instcode | VARCHAR | 255 | √ | null |
|
|
FAO WIEWS code of the institute where the accession is maintained. The codes consist of the 3-letter ISO 3166 country code of the country where the institute is located plus a number (e.g. COL001). The current set of institute codes is available from http://www.fao.org/wiews. For those institutes not yet having an FAO Code, or for those with ‘obsolete’ codes, see ‘Common formatting rules (v)’. |
||||
| accenumb | 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’). |
|||||
| collnumb | VARCHAR | 255 | √ | null |
|
|
Original identifier assigned by the collector(s) of the sample, normally composed of the name or initials of the collector(s) followed by a number (e.g. ‘FM9909’). This identifier is essential for identifying duplicates held in different collections. |
||||
| collcode | VARCHAR | 255 | √ | null |
|
|
FAO WIEWS code of the institute collecting the sample. If the holding institute has collected the material, the collecting institute code (COLLCODE) should be the same as the holding institute code (INSTCODE). Follows INSTCODE standard. Multiple values are separated by a semicolon without space. |
||||
| collname | VARCHAR | 255 | √ | null |
|
|
Name of the institute collecting the sample. This descriptor should be used only if COLLCODE cannot be filled because the FAO WIEWS code for this institute is not available. Multiple values are separated by a semicolon without space. |
||||
| collinstaddress | TEXT | 65535 | √ | null |
|
|
Address of the institute collecting the sample. This descriptor should be used only if COLLCODE cannot be filled since the FAO WIEWS code for this institute is not available. Multiple values are separated by a semicolon without space. |
||||
| collmissid | VARCHAR | 255 | √ | null |
|
|
Identifier of the collecting mission used by the Collecting Institute (4 or 4.1) (e.g. ‘CIATFOR052’, ‘CN426’). |
||||
| genus | VARCHAR | 255 | √ | null |
|
|
Genus name for taxon. Initial uppercase letter required. |
||||
| species | VARCHAR | 255 | √ | null |
|
|
Specific epithet portion of the scientific name in lowercase letters. Only the following abbreviation is allowed: ‘sp.’ |
||||
| VARCHAR | 255 | √ | null |
|
|
Provide the authority for the species name. |
|||||
| subtaxa | VARCHAR | 255 | √ | null |
|
|
Subtaxon can be used to store any additional taxonomic identifier. The following abbreviations are allowed: ‘subsp.’ (for subspecies); ‘convar.’ (for convariety); ‘var.’ (for variety); ‘f.’ (for form); ‘Group’ (for ‘cultivar group’). |
||||
| VARCHAR | 255 | √ | null |
|
|
Provide the subtaxon authority at the most detailed taxonomic level. |
|||||
| cropname | VARCHAR | 255 | √ | null |
|
|
Common name of the crop. Example: ‘malting barley’, ‘macadamia’, ‘maïs’. |
||||
| accename | VARCHAR | 255 | √ | null |
|
|
Either a registered or other designation given to the material received, other than the donor’s accession number (23) or collecting number (3). First letter uppercase. Multiple names are separated by a semicolon without space. Example: Accession name: Bogatyr;Symphony;Emma. |
||||
| acqdate | VARCHAR | 255 | √ | null |
|
|
Date on which the accession entered the collection where YYYY is the year, MM is the month and DD is the day. Missing data (MM or DD) should be indicated with hyphens or ‘00’ [double zero]. |
||||
| origcty | VARCHAR | 255 | √ | null |
|
|
3-letter ISO 3166-1 code of the country in which the sample was originally collected (e.g. landrace, crop wild relative, farmers’ variety), bred or selected (breeding lines, GMOs, segregating populations, hybrids, modern cultivars, etc.). |
||||
| collsite | VARCHAR | 255 | √ | null |
|
|
Location information below the country level that describes where the accession was collected, preferable in English. This might include the distance in kilometres and direction from the nearest town, village or map grid reference point, (e.g. 7 km south of Curitiba in the state of Parana). |
||||
| declatitude | DECIMAL | 64,10 | √ | null |
|
|
Latitude expressed in decimal degrees. Positive values are North of the Equator; negative values are South of the Equator (e.g. -44.6975). |
||||
| latitude | VARCHAR | 255 | √ | null |
|
|
Degrees (2 digits) minutes (2 digits), and seconds (2 digits) followed by N (North) or S (South) (e.g. 103020S). Every missing digit (minutes or seconds) should be indicated with a hyphen. Leading zeros are required (e.g. 10—-S; 011530N; 4531–S). |
||||
| declongitude | DECIMAL | 64,10 | √ | null |
|
|
Longitude expressed in decimal degrees. Positive values are East of the Greenwich Meridian; negative values are West of the Greenwich Meridian (e.g. +120.9123). |
||||
| longitude | VARCHAR | 255 | √ | null |
|
|
Degrees (3 digits), minutes (2 digits), and seconds (2 digits) followed by E (East) or W (West) (e.g. 0762510W). Every missing digit (minutes or seconds) should be indicated with a hyphen. Leading zeros are required (e.g. 076—-W). |
||||
| coorduncert | INT | 10 | √ | null |
|
|
Uncertainty associated with the coordinates in metres. Leave the value empty if the uncertainty is unknown. |
||||
| coorddatum | VARCHAR | 255 | √ | null |
|
|
The geodetic datum or spatial reference system upon which the coordinates given in decimal latitude and decimal longitude are based (e.g. WGS84, ETRS89, NAD83). The GPS uses the WGS84 datum. |
||||
| georefmeth | VARCHAR | 255 | √ | null |
|
|
The georeferencing method used (GPS, determined from map, gazetteer, or estimated using software). Leave the value empty if georeferencing method is not known. |
||||
| elevation | DECIMAL | 64,10 | √ | null |
|
|
Elevation of collecting site expressed in metres above sea level. Negative values are allowed. |
||||
| colldate | VARCHAR | 255 | √ | null |
|
|
Collecting date of the sample, where YYYY is the year, MM is the month and DD is the day. Missing data (MM or DD) should be indicated with hyphens or ‘00’ [double zero]. |
||||
| bredcode | VARCHAR | 255 | √ | null |
|
|
FAO WIEWS code of the institute that has bred the material. If the holding institute has bred the material, the breeding institute code (BREDCODE) should be the same as the holding institute code (INSTCODE). Follows INSTCODE standard. Multiple values are separated by a semicolon without space. |
||||
| bredname | VARCHAR | 255 | √ | null |
|
|
Name of the institute (or person) that bred the material. This descriptor should be used only if BREDCODE cannot be filled because the FAO WIEWS code for this institute is not available. Multiple names are separated by a semicolon without space. |
||||
| sampstat | INT | 10 | √ | null |
|
|
The coding scheme proposed can be used at 3 different levels of detail: either by using the general codes (in boldface) such as 100, 200, 300, 400, or by using the more specific codes such as 110, 120, etc. |
||||
| ancest | TEXT | 65535 | √ | null |
|
|
Information about either pedigree or other description of ancestral information (e.g. parent variety in case of mutant or selection). For example a pedigree ‘Hanna/7Atlas//Turk/8Atlas’ or a description ‘mutation found in Hanna’, ‘selection from Irene’ or ‘cross involving amongst others Hanna and Irene’. |
||||
| collsrc | INT | 10 | √ | null |
|
|
The coding scheme proposed can be used at 2 different levels of detail: either by using the general codes (in boldface) such as 10, 20, 30, 40, etc., or by using the more specific codes, such as 11, 12, etc. |
||||
| donorcode | VARCHAR | 255 | √ | null |
|
|
FAO WIEWS code of the donor institute. Follows INSTCODE standard. |
||||
| donorname | VARCHAR | 255 | √ | null |
|
|
Name of the donor institute (or person). This descriptor should be used only if DONORCODE cannot be filled because the FAO WIEWS code for this institute is not available. |
||||
| donornumb | VARCHAR | 255 | √ | null |
|
|
Identifier assigned to an accession by the donor. Follows ACCENUMB standard. |
||||
| othernumb | TEXT | 65535 | √ | null |
|
|
Any other identifiers known to exist in other collections for this accession. Use the following format: INSTCODE:ACCENUMB;INSTCODE:identifier;… INSTCODE and identifier are separated by a colon without space. Pairs of INSTCODE and identifier are separated by a semicolon without space. When the institute is not known, the identifier should be preceded by a colon. |
||||
| duplsite | VARCHAR | 255 | √ | null |
|
|
FAO WIEWS code of the institute(s) where a safety duplicate of the accession is maintained. Multiple values are separated by a semicolon without space. Follows INSTCODE standard. |
||||
| duplinstname | VARCHAR | 255 | √ | null |
|
|
Name of the institute where a safety duplicate of the accession is maintained. Multiple values are separated by a semicolon without space. |
||||
| storage | TEXT | 65535 | √ | null |
|
|
If germplasm is maintained under different types of storage, multiple choices are allowed, separated by a semicolon (e.g. 20;30). (Refer to FAO/IPGRI Genebank Standards 1994 for details on storage type.) |
||||
| mlsstat | INT | 10 | √ | null |
|
|
The status of an accession with regards to the Multilateral System (MLS) of the International Treaty on Plant Genetic Resources for Food and Agriculture. Leave the value empty if the status is not known |
||||
| remarks | TEXT | 65535 | √ | null |
|
|
The remarks field is used to add notes or to elaborate on descriptors with value 99 or 999 (= Other). Prefix remarks with the field name they refer to and a colon (:) without space (e.g. COLLSRC:riverside). Distinct remarks referring to different fields are separated by semicolons without space. |
||||
| created_on | DATETIME | 19 | √ | CURRENT_TIMESTAMP |
|
|
Date and time when this record was created. |
||||
| updated_on | TIMESTAMP | 19 | √ | CURRENT_TIMESTAMP |
|
|
Timestamp of the last update to this record. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | germinatebase_id |
| collsrc | Performance | Asc | collsrc |
| mlsstat | Performance | Asc | mlsstat |
| sampstat | Performance | Asc | sampstat |