1 |
|
id |
int(10, 0) |
|
Identity / Auto increment column
|
|
Primary id for this table. This uniquely identifies the row. |
Primary id for this table. This uniquely identifies the row.
Identity / Auto increment column
|
2 |
|
general_identifier |
varchar(255) |
|
|
|
A unique identifier. |
A unique identifier.
|
3 |
|
number |
varchar(255) |
|
|
|
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’). |
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’).
|
4 |
|
name |
varchar(255) |
|
|
|
A unique name which defines an entry in the germinatbase table. |
A unique name which defines an entry in the germinatbase table.
|
5 |
|
bank_number |
varchar(255) |
|
|
|
Alternative genebank number. |
Alternative genebank number.
|
6 |
|
breeders_code |
char(50) |
|
|
|
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. |
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.
|
7 |
|
breeders_name |
varchar(255) |
|
|
|
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. |
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.
|
8 |
|
subtaxa_id |
int(10, 0) |
|
|
subtaxa |
Foreign key to subtaxa (subtaxa.id). |
Foreign key to subtaxa (subtaxa.id).
References:
subtaxa
|
9 |
|
taxonomy_id |
int(10, 0) |
|
|
taxonomies |
Foreign key to taxonomies (taxonomies.id). |
Foreign key to taxonomies (taxonomies.id).
References:
taxonomies
|
10 |
|
institution_id |
int(10, 0) |
|
|
institutions |
Foreign key to institutions (institutions.id). |
Foreign key to institutions (institutions.id).
References:
institutions
|
11 |
|
plant_passport |
varchar(255) |
|
|
|
Record if the entry has a plant passport. |
Record if the entry has a plant passport.
|
12 |
|
donor_code |
varchar(255) |
|
|
|
FAO WIEWS code of the donor institute. Follows INSTCODE standard. |
FAO WIEWS code of the donor institute. Follows INSTCODE standard.
|
13 |
|
donor_name |
varchar(255) |
|
|
|
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. |
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.
|
14 |
|
donor_number |
varchar(255) |
|
|
|
Identifier assigned to an accession by the donor. Follows ACCENUMB standard. |
Identifier assigned to an accession by the donor. Follows ACCENUMB standard.
|
15 |
|
acqdate |
varchar(255) |
|
|
|
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]. |
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].
|
16 |
|
collnumb |
varchar(255) |
|
|
|
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. |
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.
|
17 |
|
colldate |
date |
|
|
|
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]. |
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].
|
18 |
|
collcode |
varchar(255) |
|
|
|
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. |
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.
|
19 |
|
collname |
varchar(255) |
|
|
|
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. |
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.
|
20 |
|
collmissid |
varchar(255) |
|
|
|
Identifier of the collecting mission used by the Collecting Institute (4 or 4.1) (e.g. 'CIATFOR-052', 'CN426'). |
Identifier of the collecting mission used by the Collecting Institute (4 or 4.1) (e.g. 'CIATFOR-052', 'CN426').
|
21 |
|
othernumb |
text |
|
|
|
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. |
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.
|
22 |
|
duplsite |
varchar(255) |
|
|
|
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. |
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.
|
23 |
|
duplinstname |
varchar(255) |
|
|
|
Name of the institute where a safety duplicate of the accession is maintained. Multiple values are separated by a semicolon without space. |
Name of the institute where a safety duplicate of the accession is maintained. Multiple values are separated by a semicolon without space.
|
24 |
|
mlsstatus_id |
int(10, 0) |
|
|
mlsstatus |
Foreign key to mlsstatus (mlsstatus.id). |
Foreign key to mlsstatus (mlsstatus.id).
References:
mlsstatus
|
25 |
|
puid |
varchar(255) |
|
|
|
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. |
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.
|
26 |
|
biologicalstatus_id |
int(10, 0) |
|
|
biologicalstatus |
Foreign key to biologicalstatus (biologicalstaus.id). |
Foreign key to biologicalstatus (biologicalstaus.id).
References:
biologicalstatus
|
27 |
|
collsrc_id |
int(10, 0) |
|
|
collectingsources |
Foreign key to collectionsources (collectionsources.id). |
Foreign key to collectionsources (collectionsources.id).
References:
collectingsources
|
28 |
|
location_id |
int(10, 0) |
|
|
locations |
Foreign key to locations (locations.id). |
Foreign key to locations (locations.id).
References:
locations
|
29 |
|
entitytype_id |
int(10, 0) |
|
Default:
1 |
entitytypes |
Foreign key to entitytypes (entitytypes.id). |
Foreign key to entitytypes (entitytypes.id).
Default:
1
References:
entitytypes
|
30 |
|
entityparent_id |
int(10, 0) |
|
|
germinatebase |
Foreign key to germinatebase (germinatebase.id). |
Foreign key to germinatebase (germinatebase.id).
References:
germinatebase
|
31 |
|
pdci |
float(64, 10) |
|
|
|
Passport Data Completeness Index. This is calculated by Germinate. Manual editing of this field will be overwritten. |
Passport Data Completeness Index. This is calculated by Germinate. Manual editing of this field will be overwritten.
|
32 |
|
created_on |
datetime |
|
Default:
CURRENT_TIMESTAMP |
|
When the record was created. |
When the record was created.
Default:
CURRENT_TIMESTAMP
|
33 |
|
updated_on |
timestamp |
|
Default:
CURRENT_TIMESTAMP |
|
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record. |
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record.
Default:
CURRENT_TIMESTAMP
|