taxonomies


Description

The species table holds information relating to the species that are deinfed within a particular Germinate instance including common names and ploidy levels.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
germinatebase.taxonomy_id germinatebase_ibfk_taxonomy N
taxonomyproviderslinks.taxonomy_id taxonomyproviderslinks_ibfk_1 C

Primary id for this table. This uniquely identifies the row.
genus VARCHAR 255

Genus name for the species.
species VARCHAR 255

Species name in lowercase.
subtaxa VARCHAR 255 √ null

Subtaxa name.
species_author VARCHAR 255 √ null

also known as spauthor in the Multi Crop Passport Descriptors (MCPD V2 2012). Describes the authority for the species name.
subtaxa_author VARCHAR 255 √ null

also known as subtauthor in the Multi Crop Passport Descriptors (MCPD V2 2012).
cropname VARCHAR 255 √ null

The name of the crop. This should be the common name. Examples would include barley, maize, wheat, rice and so on.
ploidy INT 10 √ null

Defines the ploidy level for the species. Use numbers to reference ploidy for example diploid = 2, tetraploid = 4.
created_on DATETIME 19 √ CURRENT_TIMESTAMP

When the record was created.
updated_on TIMESTAMP 19 √ 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.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation