| Column | Type | Size | Nulls | Auto | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dataset_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
|||||||||||||
| master_set_id | int4 | 10 | √ |
|
|
Specifies the master set to which this dataset belongs. |
|||||||||||||
| data_type_id | int4 | 10 |
|
|
Specifies the type of data contained in the dataset. |
||||||||||||||
| method_id | int4 | 10 | √ |
|
|
Specifies the method of analysis used for this dataset. |
|||||||||||||
| biblio_id | int4 | 10 | √ |
|
|
Specifies the publication that describes or mentions the dataset. |
|||||||||||||
| updated_dataset_id | int4 | 10 | √ |
|
|
Specifies any subsequent version of this dataset. |
|||||||||||||
| project_id | int4 | 10 | √ |
|
|
Specifies the project related to this dataset. |
|||||||||||||
| dataset_name | varchar(50) | 50 |
|
|
A unique identifier for the dataset at this site, potentially matching the sample group name or created for clarity and context. |
||||||||||||||
| date_updated | timestamptz | 35,6 | √ |
|
|
||||||||||||||
| dataset_uuid | uuid | 2147483647 |
|
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_datasets_pkey | Primary key | Asc | dataset_id |
| idx_datasets_biblio_id | Performance | Asc | biblio_id |
| idx_datasets_data_type_id | Performance | Asc | data_type_id |
| idx_datasets_master_set_id | Performance | Asc | master_set_id |
| idx_datasets_method_id | Performance | Asc | method_id |
| idx_datasets_project_id | Performance | Asc | project_id |
| idx_datasets_updated_dataset_id | Performance | Asc | updated_dataset_id |
| pk_tbl_datasets | Must be unique | Asc | dataset_uuid |
