tbl_datasets

59042 rows


Description

The tbl_datasets table organizes collections of analysis entities into datasets, which are structured collections relevant to the specific proxy being studied. For biological proxies, a dataset typically corresponds to a spreadsheet containing samples and taxa for a single analysis method, such as phosphates through citric acid extraction.

Columns

Column Type Size Nulls Auto Children Parents Comments
dataset_id int4 10 √
tbl_analysis_entities.dataset_id fk_analysis_entities_dataset_id R
tbl_dataset_contacts.dataset_id fk_dataset_contacts_dataset_id R
tbl_dataset_submissions.dataset_id fk_dataset_submissions_dataset_id R
tbl_datasets.updated_dataset_id fk_datasets_updated_dataset_id R

Primary key (automatically incremented).
master_set_id int4 10 √
tbl_dataset_masters.master_set_id fk_datasets_master_set_id R

Specifies the master set to which this dataset belongs.
data_type_id int4 10
tbl_data_types.data_type_id fk_datasets_data_type_id R

Specifies the type of data contained in the dataset.
method_id int4 10 √
tbl_methods.method_id fk_datasets_method_id R

Specifies the method of analysis used for this dataset.
biblio_id int4 10 √
tbl_biblio.biblio_id fk_datasets_biblio_id R

Specifies the publication that describes or mentions the dataset.
updated_dataset_id int4 10 √
tbl_datasets.dataset_id fk_datasets_updated_dataset_id R

Specifies any subsequent version of this dataset.
project_id int4 10 √
tbl_projects.project_id fk_datasets_project_id R

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

Indexes

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

Relationships

Close relationships within degrees of separation