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 |
|
|
||
| created_on | DATETIME | 26 | √ | null |
|
|
When the record was created. |
|
| 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. |
|
| publications | BIGINT | 19 | √ | null |
|
|
||
| collaborators | BIGINT | 19 | √ | null |
|
|
||
| attributes | BIGINT | 19 | √ | null |
|
|
||
| accepted_by | JSON | 1073741824 | √ | null |
|
|