global_DataSetMaster

311 rows


Description

Is the global master table that stores dataset related information for all relevant compilations. A Dataset is the set of samples for a particular data type, e.g. pollen, from a certain collection unit (according to Neotoma db). Dataset types are defined in the cabah_datasettypeID table. In OCTOPUS data model hierarchy global_DataSetID is situated between the collection-specific sample tables (subordinate) and the global_UnitMaster table (superordinate); (= UNITID). global_DataSetID table is exclusively used for collections with a corresponding demand, i.e., will be bypassed for any collection that does not deal with multiple samples / observations from one and the same location / site / unit (e.g. a core).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DATASETID serial 10 √ nextval('"global_DataSetID_DATASETID_seq"'::regclass)
global_datasetpublicationID.DATASETID <--DATASETID_from_global_DataSetMaster_fkey R
ippd_baseline_pollen.DATASETID Implied Constraint R
ippd_datasets.DATASETID Implied Constraint R
ippd_Sample.DATASETID <--DATASETID_from_global_DataSetMaster_fkey R
UNITID int4 10 null
global_UnitMaster.UNITID <--UNITID_from_global_UnitMaster_fkey R

Is dataset parent unit ID
DSETTYPEID int2 5 null
global_datasettypeID.DSETTYPEID <--DSETTYPEID_from_global_datasettypeID_fkey R

Is type of dataset
NEODSETID int4 10 √ null
ippd_Sample.NEODSETID <--NEODSETID_from_global_DataSetMaster_fkey R

Is matching Neotoma dataset ID
NEODSETDOI text 2147483647 √ null

Is matching Neotoma dataset DOI
DSETNAME text 2147483647 √ null

Is dataset name
DSETSOURCE int4 10 √ null
cabah_datasourceID.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R

Is dataset source
DSETAGEOLD numeric 0 √ null

Is oldest dataset age
DSETAGEYNG numeric 0 √ null

Is youngest dataset age
DSETNOTE text 2147483647 √ null

Is dataset note
CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC
UPDATED_AT timestamptz 35,6 √ timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC

Indexes

Constraint Name Type Sort Column(s)
global_DataSetID_pkey Primary key Asc DATASETID
neodsetid_unique Must be unique Asc NEODSETID

Relationships

Close relationships within degrees of separation