global_datasetpublicationID

403 rows


Description

Is Neotoma-derived lookup table for compilations involving datasets, e.g. IPPD. This table stores dataset publications. NOTE – DATASETID and REFDBID together form a combined primary key.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DATASETID int4 10 null
global_DataSetMaster.DATASETID <--DATASETID_from_global_DataSetMaster_fkey R
REFDBID text 2147483647 null
global_RefCore.REFDBID <--REFDBID_from_global_RefCore_fkey R
NEODSETID int4 10 √ null
NEO_REFID int4 10 √ null
PRIMARYPUB bool 1 √ null
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_datasetpublicationID_pkey Primary key Asc/Asc DATASETID + REFDBID

Relationships

Close relationships within degrees of separation