ippd_DataCore

384434 rows


Description

Is an IPPD-specific Neotoma table where each occurrence of a Variable in a sample comprises a record in the Data table. Data is the primary table in Neotoma’s data model. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#data)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DATAID int4 10 null
ippd_baseline_pollen.DATAID Implied Constraint R

Arbitrary identifier. Is original Neotoma dataid
SAMPLEID int4 10 null
ippd_Sample.SAMPLEID <--SAMPLEID_from_ippd_Sample_fkey R

Is fkey to public.“ippd_Sample”
VARIABLEID int4 10 null
ippd_variables.VARIABLEID <--VARIABLEID_from_ippd_variables_fkey R

Is fkey to public.“ippd_variables”
VALUE numeric 0 √ null

Is the value of the variable
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)
ippd_DataCore_pkey Primary key Asc DATAID

Relationships

Close relationships within degrees of separation