arch_c14_DataCore

9501 rows


Description

Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model entity) for the SahulArch/ Radiocarbon collection and is subordinate to the arch_Sample table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBSID1 text 2147483647 null
arch_c14_polygons_EPSG3857.OBSID1 <--OBSID1_from_arch_c14_DataCore_fkey R
SMPID text 2147483647 null
arch_Sample.SMPID <--SMPID_from_arch_Sample_fkey R
OBSID2 text 2147483647 √ null
LABID text 2147483647 √ null
IGSNID text 2147483647 √ null
LAB_ORIGID int2 5 √ null
cabah_LabCodes.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
METHODID int2 5 null
cabah_methodID.METHODID <--METHODID_from_cabah_methodID_fkey R
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
COL_MTDID int2 5 √ null
cabah_col_mtdID.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R
MATERIA1ID int2 5 √ null
c14_materia1ID.MATERIA1ID <--MATERIA1ID_from_C14_materia1ID_fkey R
MATERIA2ID int2 5 √ null
c14_materia2ID.MATERIA2ID <--MATERIA2ID_from_C14_materia2ID_fkey R
BURNT varchar 3 √ null
ARCHSPECIS text 2147483647 √ null
ORGPART text 2147483647 √ null
HUM_MODID int2 5 √ null
c14_hum_modID.HUM_MODID <--HUM_MODID_from_c14_hum_modID_fkey R
SINGULAR varchar 3 √ null
CONSERV varchar 3 √ null
AGEMTD varchar 4 √ null
PHYSCLEAN varchar 3 √ null
CONTAMID int2 5 √ null
c14_contamID.CONTAMID <--CONTAMID_from_c14_contamID_fkey R
CHEMPREPID int2 5 √ null
cabah_chemprepID.CHEMPREPID <--CHEMPREPID_from_cabah_chemprepID_fkey R
SOLVENT1 varchar 3 √ null
SOLVENT2ID int2 5 √ null
c14_solvent2ID.SOLVENT2ID <--SOLVENT2ID_from_solvent2ID_fkey R
YIELD_MG numeric 0 √ null
YIELD_PCT numeric 0 √ null
C numeric 0 √ null
C_ERR numeric 0 √ null
C_MTDID int2 5 √ null
c_mtdID.C_MTDID <--C_MTDID_from_c_mtdID_fkey R
PCT_C numeric 0 √ null
PCT_C_ERR numeric 0 √ null
PCT_C_MTID int2 5 √ null
c_mtdID.C_MTDID pctc<--C_MTDID_from_c_mtdID_fkey R
PCT_N numeric 0 √ null
PCT_N_ERR numeric 0 √ null
PCT_N_MTID int2 5 √ null
c_mtdID.C_MTDID pctn<--C_MTDID_from_c_mtdID_fkey R
CN_RATIO numeric 0 √ null
CN_ERR numeric 0 √ null
CN_MTDID int2 5 √ null
c_mtdID.C_MTDID cn<--C_MTDID_from_c_mtdID_fkey R
C13 numeric 0 √ null
C13_ERR numeric 0 √ null
C13_MTDID int2 5 √ null
c_mtdID.C_MTDID c13<--C_MTDID_from_c_mtdID_fkey R
O18 numeric 0 √ null
O18_ERR numeric 0 √ null
O18_MTDID int2 5 √ null
c_mtdID.C_MTDID o18<--C_MTDID_from_c_mtdID_fkey R
N15 numeric 0 √ null
N15_ERR numeric 0 √ null
N15_MTDID int2 5 √ null
c_mtdID.C_MTDID n15<--C_MTDID_from_c_mtdID_fkey R
S34 numeric 0 √ null
S34_ERR numeric 0 √ null
S34_MTDID int2 5 √ null
c_mtdID.C_MTDID s34<--C_MTDID_from_c_mtdID_fkey R
RECRYST varchar 3 √ null
PCT_RE_VAL numeric 0 √ null
PCT_RE_ERR numeric 0 √ null
PCT_RE_MTD varchar 5 √ null
C14_AGE numeric 0 √ null
C14_ERRPOS numeric 0 √ null
C14_ERRNEG numeric 0 √ null
C14_INF varchar 3 √ null
F14C numeric 0 √ null
F14C_ERR numeric 0 √ null
C13_VALID int2 5 √ null
c13_valID.C13_VALID <--C13_VALID_from_c13_valID_fkey R
AGE_COMMT 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

Indexes

Constraint Name Type Sort Column(s)
arch_c14_DataCore_pkey Primary key Asc OBSID1

Relationships

Close relationships within degrees of separation