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 |