datasets

59553 rows


Description

This table stores the data for Datasets. A Dataset is the set of samples for a particular data type from a Collection Unit. A Collection Unit may have multiple Datasets for different data types, for example one dataset for pollen and another for plant macrofossils. Every Sample is assigned to a Dataset, and every Dataset is assigned to a Collection Unit. Samples from different Collection Units cannot be assigned to the same Dataset (although they may be assigned to Aggregate Datasets).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
datasetid serial 10 √ nextval('ndb.seq_datasets_datasetid'::regclass)
dataprocessors.datasetid fk_dataprocessors_datasets C
datasetdatabases.datasetid fk_datasetdatabases_datasets C
datasetpis.datasetid fk_datasetpis_datasets C
datasetpublications.datasetid fk_datasetpublications_datasets C
datasetsubmissions.datasetid fk_datasetsubmissions_datasets C
datasettaxonnotes.datasetid fk_datasettaxonnotes_datasets C
datasetvariables.datasetid fk_datasetvariables_datasets C
dsageranges.datasetid Implied Constraint R
dsdatasample.datasetid Implied Constraint R
dslinks.datasetid Implied Constraint R
dssampdata.datasetid Implied Constraint R
isoinstrumentation.datasetid fk_isoinstrumentation_datasets C
isosrmetadata.datasetid fk_isosrmetadata_datasets C
isostandards.datasetid fk_isostandards_datasets C
repositoryspecimens.datasetid fk_repositoryspecimens_datasets C
samples.datasetid fk_samples_datasets C
synonymy.datasetid fk_synonymy_datasets C

An arbitrary Dataset identification number.
collectionunitid int4 10 null
collectionunits.collectionunitid fk_datasets_collectionunits C

Collection Unit identification number. Field links to the CollectionUnits table.
datasettypeid int4 10 null
datasettypes.datasettypeid fk_datasets_datasettypes C

Dataset Type identification number. Field links to the DatasetTypes lookup table.
datasetname varchar 80 √ null

Optional name for the Dataset.
notes text 2147483647 √ null

Free form notes or comments about the Dataset.
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
embargoid int4 10 √ null
embargo.embargoid fk_datasets_embargo C

Indexes

Constraint Name Type Sort Column(s)
datasets_pkey Primary key Asc datasetid
idx_datasets_collectionunit Performance Asc/Asc/Asc collectionunitid + datasetid + datasettypeid
ix_collectionunitid_datasets Performance Asc collectionunitid
ix_datasettypeid_datasets Performance Asc datasettypeid

Relationships

Close relationships within degrees of separation