germinatebase


Description

Germinatebase is the Germinate base table which contains passport and other germplasm definition data.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
germinatebase.entityparent_id germinatebase_ibfk_entityparent N
germplasmdatawarnings.germinatebase_id germplasmdatawarnings_ibfk_1 C
germplasminstitutions.germinatebase_id germplasminstitutions_ibfk_1 C
mcpd.germinatebase_id mcpd_ibfk_1 C
pedigreedefinitions.germinatebase_id pedigreedefinitions_ibfk_1 C
pedigrees.germinatebase_id pedigrees_ibfk_1 C
pedigrees.parent_id pedigrees_ibfk_2 C
trialsetup.germinatebase_id trialsetup_ibfk_1 C

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

A unique identifier.
number 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’).
name VARCHAR 255 null

A unique name which defines an entry in the germinatbase table.
display_name VARCHAR 255 null

The name to be displayed on user interfaces and to be exported to external tools like Flapjack and Helium.
bank_number VARCHAR 255 √ null

Alternative genebank number.
taxonomy_id INT 10 √ null
taxonomies.id germinatebase_ibfk_taxonomy N

Foreign key to taxonomies (taxonomies.id).
plant_passport VARCHAR 255 √ null

Record if the entry has a plant passport.
location_id INT 10 √ null
locations.id germinatebase_ibfk_location N

Foreign key to locations (locations.id).
entitytype_id INT 10 √ 1
entitytypes.id germinatebase_ibfk_entitytype N

Foreign key to entitytypes (entitytypes.id).
entityparent_id INT 10 √ null
germinatebase.id germinatebase_ibfk_entityparent N

Foreign key to germinatebase (germinatebase.id).
pdci FLOAT 64,10 √ null

Passport Data Completeness Index. This is calculated by Germinate. Manual editing of this field will be overwritten.
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
collsite_id Performance Asc location_id
general_identifier Performance Asc general_identifier
germinatebase_display_name Performance Asc display_name
germinatebase_ibfk_entityparent Performance Asc entityparent_id
germinatebase_ibfk_entitytype Performance Asc entitytype_id
germinatebase_name Performance Asc name
germinatebase_number Performance Asc number
taxonomy_id Performance Asc taxonomy_id

Relationships

Close relationships within degrees of separation