expage_DataCore

16009 rows


Description

Is Expage data table. This table stores observations (= smallest datamodel intity) for the Expage compilation and is subordinate to the expage_Sample table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBSID1 text 2147483647 null
expage_points_EPSG3857.OBSID1 <--OBSID1_from_expage_DataCore_fkey R
SMPID text 2147483647 null
expage_Sample.SMPID <--SMPID_from_expage_Sample_fkey R
OBSID2 text 2147483647 √ null
IGSNID text 2147483647 √ null
VERID int2 5 null
global_dbDOI.VERID <--VERID_from_global_dbDOI_fkey R
REFDBID1 text 2147483647 null
global_RefCore.REFDBID <--REFDBID(1)_from_global_RefCore_fkey R
REFDBID2 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID(2)_from_global_RefCore_fkey R
REFDBID3 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID(3)_from_global_RefCore_fkey R
REFDBID4 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID(4)_from_global_RefCore_fkey R
BE10NP int8 19 √ null
BE10NP_ERR int8 19 √ null
BESTNDID int2 5 √ null
crn_bestndID.BESTNDID <--BESTNDID_from_crn_bestndID_fkey R
BE10AP numeric 0 √ null
BE10AP_ERR numeric 0 √ null
AL26NP int8 19 √ null
AL26NP_ERR int8 19 √ null
ALSTNDID int2 5 √ null
crn_alstndID.ALSTNDID <--ALSTNDID_from_crn_alstndID_fkey R
AL26AP numeric 0 √ null
AL26AP_ERR numeric 0 √ null
ABE_YR numeric 0 √ null
ABE_ERREXT numeric 0 √ null
ABE_ERRINT numeric 0 √ null
AAL_YR numeric 0 √ null
AAL_ERREXT numeric 0 √ null
AAL_ERRINT numeric 0 √ 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)
expage_DataCore_pkey Primary key Asc OBSID1

Relationships

Close relationships within degrees of separation