datasets


Description

Datasets which are defined within Germinate although there can be external datasets which are links out to external data sources most will be held within Germinate.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
climatedata.dataset_id climatedata_ibfk_1 C
datasetaccesslogs.dataset_id datasetaccesslogs_ibfk_1 C
datasetcollaborators.dataset_id datasetcollaborators_ibfk_1 C
datasetfileresources.dataset_id datasetfileresources_ibfk_1 C
datasetlocations.dataset_id datasetlocations_ibfk_1 C
datasetmembers.dataset_id datasetmembers_ibfk_1 C
datasetmeta.dataset_id datasetmeta_ibfk_1 C
datasetpermissions.dataset_id datasetpermissions_ibfk_1 C
mapoverlays.dataset_id mapoverlays_ibfk_1 C
pedigreedefinitions.dataset_id pedigreedefinitions_ibfk_4 C
pedigrees.dataset_id pedigrees_ibfk_4 C
trialsetup.dataset_id trialsetup_ibfk_2 C

Primary id for this table. This uniquely identifies the row.
experiment_id INT 10 0
experiments.id datasets_ibfk_experiment C

Foreign key to experiments (experiments.id).
datasettype_id INT 10 -1
datasettypes.id datasets_ibfk_datasettypes C

Foreign key to datasettypes (datasettypes.id).
name MEDIUMTEXT 16777215 null

Describes the dataset.
description MEDIUMTEXT 16777215 √ null

The name of this dataset.
date_start DATE 10 √ null

Date that the dataset was generated.
date_end DATE 10 √ null

Date at which the dataset recording ended.
source_file VARCHAR 255 √ null
datatype VARCHAR 255 √ null

A description of the data type of the contained data. Examples might be: “raw data”, “BLUPs”, etc.
dublin_core JSON 1073741824 √ null
version CHAR 10 √ null

Dataset version if this exists.
created_by INT 10 √ null

Defines who created the dataset. This is a FK in Gatekeeper users table. Foreign key to Gatekeeper users (users.id).
dataset_state_id INT 10 1
datasetstates.id datasets_ibfk_dataset_state C

Foreign key to datasetstates (datasetstates.id).
license_id INT 10 √ null
licenses.id datasets_ibfk_license N
is_external BIT 1 √ 0

Defines if the dataset is contained within Germinate or from an external source and not stored in the database.
hyperlink VARCHAR 255 √ null

Link to access the external dasets.
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.
contact VARCHAR 255 √ null

The contact to get more information about this dataset.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
datasets_ibfk_2 Performance Asc dataset_state_id
datasets_ibfk_datasettypes Performance Asc datasettype_id
experiment Performance Asc experiment_id
id Performance Asc id
license_id Performance Asc license_id

Relationships

Close relationships within degrees of separation