Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
Primary id for this table. This uniquely identifies the row. |
|||||||||||||||||||
experiment_id | INT | 10 | 0 |
|
|
Foreign key to experiments (experiments.id). |
||||||||||||||||||||
datasettype_id | INT | 10 | -1 |
|
|
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 |
|
|
Foreign key to datasetstates (datasetstates.id). |
||||||||||||||||||||
license_id | INT | 10 | √ | null |
|
|
||||||||||||||||||||
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 | 26 | √ | CURRENT_TIMESTAMP |
|
|
When the record was created. |
|||||||||||||||||||
updated_on | TIMESTAMP | 26 | √ | 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 |