char_DataCore

48234 rows


Description

Is Sahul Charcoal / Black Carbon (SahulChar) data table. This table stores observations (= smallest data model entity) for the SahulChar collection and is subordinate to the char_Sample table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBSID serial 10 √ nextval('"char_DataCore_OBSID_seq"'::regclass)
sahulchar.OBSID Implied Constraint R
SMPID int4 10 null
char_Sample.SMPID <--SMPID_from_char_Sample_fkey R
OBSNAME text 2147483647 null
LABID text 2147483647 √ null
LAB_ORIGID int2 5 √ null
cabah_LabCodes.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
WHATAMI int2 5 null
global_varunitID.V_UNITID <--V_UNITID_for_WHATAMI_from_global_varunitID_fkey R
AGE numeric 12,2 √ NULL::numeric
AGE_ERROR numeric 12,2 √ NULL::numeric
AGETYPEID int2 5 √ null
cabah_agetypeID.AGETYPEID <--AGETYPEID_from_cabah_agetypeID_fkey R
AGE_SPEC varchar 12 √ NULL::character varying
METHODID int2 5 √ null
cabah_methodID.METHODID <--METHODID_from_cabah_methodID_fkey R
MATERIA2ID int2 5 √ null
c14_materia2ID.MATERIA2ID <--MATERIA2ID_from_c14_materia2ID_fkey R
EST_AGE numeric 12,2 √ NULL::numeric
CALCURVEID int2 5 √ null
c14_calcurve.CALCURVEID <--CALCURVEID_from_c14_calcurve_fkey R
CALPROGID int2 5 √ null
c14_calprogram.CALPROGID <--CALPROGID_from_c14_calprogram_fkey R
CHARCOUNTS numeric 0 √ null
CHARMTDID int2 5 √ null
cabah_charmethodID.CHARMTDID <--CHARMTDID_from_c14_charmethodID_fkey R
CHARMEASID int2 5 √ null
global_varunitID.V_UNITID <--V_UNITID_for_CHARMEASID_from_global_varunitID_fkey R
CHARMAX numeric 0 √ null
CHARMIN numeric 0 √ null
CHARSIZEID int2 5 √ null
global_varunitID.V_UNITID <--V_UNITID_for_CHARSIZEID_from_global_varunitID_fkey R
THICKNESS numeric 8,2 √ NULL::numeric
DATASRCID int2 5 √ null
cabah_datasourceID.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R
REFDBID1 text 2147483647 null
global_RefCore.REFDBID <--REFDBID_for_REF1_from_global_RefCore_fkey R
REFDBID2 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID_for_REF2_from_global_RefCore_fkey R
REFDBID3 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID_for_REF3_from_global_RefCore_fkey R
CHARCOMMT text 2147483647 √ 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
VERID int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
char_DataCore_pkey Primary key Asc OBSID

Relationships

Close relationships within degrees of separation