ippd_Sample

18370 rows


Description

Is an IPPD-specific Neotoma table that stores samples. In Neotoma’s data model, Samples belong to Analysis Units, which belong to Collection Units, which belong to Sites. However, Samples also belong to a Dataset, and the Dataset determines the type of sample. Thus, there could be two different samples from the same Analysis Unit, one belonging to a pollen dataset, the other to a plant macrofossil dataset. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#samples)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SAMPLEID int4 10 null
ippd_DataCore.SAMPLEID <--SAMPLEID_from_ippd_Sample_fkey R
ippd_sampleages.SAMPLEID <--SAMPLEID_from_ippd_Sample_fkey R
ippd_samplekeywords.SAMPLEID <--SAMPLEID_from_ippd_Sample_fkey R

Arbitrary identifier. Is original Neotoma sampleid
ANLYSUNTID int4 10 null
cabah_AnalysisUnit.ANLYSUNTID <--ANLYSUNTID_from_cabah_AnalysisUnit_fkey R

Arbitrary identifier. Is original Neotoma analysisunitid. Is fkey to public.“cabah_AnalysisUnit”
NEODSETID int4 10 null
global_DataSetMaster.NEODSETID <--NEODSETID_from_global_DataSetMaster_fkey R

Arbitrary identifier. Is “NEODSETID”, i.e., the original Neotoma datasetid. Is fkey to public.“global_DataSetMaster”
SMPNAME text 2147483647 √ null

Is sample name, if avaiable
ANLYSDATE varchar 10 √ NULL::character varying

Is date of analysis, if available
LABNUMBER text 2147483647 √ null

Is lab number, if provided
PREPMETHOD text 2147483647 √ null

Is preparation method free text field
SMPNOTE text 2147483647 √ null

Is sample note, if applicable
SMPDATE varchar 10 √ NULL::character varying

Is date of sampling, if provided
TAXONID int4 10 √ null
cabah_taxaID.TAXONID <--TAXONID_from_cabah_taxaID_fkey R

Is fkey to public.“cabah_taxaID”
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
DATASETID int4 10 null
global_DataSetMaster.DATASETID <--DATASETID_from_global_DataSetMaster_fkey R

Indexes

Constraint Name Type Sort Column(s)
ippd_Sample_pkey Primary key Asc SAMPLEID

Relationships

Close relationships within degrees of separation