Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
dataset_id | INT | 10 | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
||
dataset_name | MEDIUMTEXT | 16777215 | null |
|
|
Describes the dataset. |
||
dataset_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
The name of this dataset. |
|
hyperlink | VARCHAR | 255 | √ | null |
|
|
Link to access the external dasets. |
|
source_file | VARCHAR | 255 | √ | null |
|
|
||
version | CHAR | 10 | √ | null |
|
|
Dataset version if this exists. |
|
dataset_type | VARCHAR | 255 | √ | null |
|
|
Describes the experiment type. |
|
experiment_id | INT | 10 | √ | 0 |
|
|
Primary id for this table. This uniquely identifies the row. |
|
experiment_name | VARCHAR | 255 | √ | null |
|
|
The name of the experiment. |
|
experiment_description | MEDIUMTEXT | 16777215 | √ | null |
|
|
Describes the experiment. |
|
datatype | VARCHAR | 255 | √ | null |
|
|
A description of the data type of the contained data. Examples might be: “raw data”, “BLUPs”, etc. |
|
dataset_state | VARCHAR | 255 | √ | null |
|
|
Defines the datasetstate. |
|
locations | JSON | 1073741824 | √ | null |
|
|
||
license_id | INT | 10 | √ | 0 |
|
|
||
license_name | VARCHAR | 255 | √ | null |
|
|
||
contact | VARCHAR | 255 | √ | null |
|
|
The contact to get more information about this dataset. |
|
start_date | DATE | 10 | √ | null |
|
|
Date that the dataset was generated. |
|
end_date | DATE | 10 | √ | null |
|
|
Date at which the dataset recording ended. |
|
dublin_core | JSON | 1073741824 | √ | null |
|
|
||
updated_on | TIMESTAMP | 26 | √ | null |
|
|
When the record was updated. This may be different from the created on date if subsequent changes have been made to the underlying record. |
|
data_object_count | BIGINT UNSIGNED | 20 | √ | null |
|
|
The number of data objects contained in this dataset. |
|
data_point_count | BIGINT UNSIGNED | 20 | √ | null |
|
|
The number of individual data points contained in this dataset. |
|
is_external | BIT | 1 | √ | 0 |
|
|
Defines if the dataset is contained within Germinate or from an external source and not stored in the database. |
|
collaborators | BIGINT | 19 | √ | null |
|
|
||
attributes | BIGINT | 19 | √ | null |
|
|
||
accepted_by | JSON | 1073741824 | √ | null |
|
|