arch_osl_DataCore

973 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBSID1 text 2147483647 null
arch_osl_polygons_EPSG3857.OBSID1 <--OBSID1_from_arch_osl_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
LUM_MATID int2 5 √ null
osl-tl_lum_matID.LUM_MATID <--LUM_MATID_from_osl-tl_lum_matID_fkey R
MINERALID int2 5 √ null
osl-tl_mineralID.MINERALID <--MINERALID_from_osl-tl_mineralID_fkey R
SIZE_MIN int2 5 √ null
SIZE_MAX int2 5 √ null
H2O_MEAS numeric 0 √ null
H2O_USED numeric 0 √ null
H2O_ERR numeric 0 √ null
OSL_TYPEID int2 5 √ null
osl_typeID.OSL_TYPEID <--OSL_TYPEID_from_osl_typeID_fkey R
ALIQ_TYPE varchar 3 √ null
ALIQ_SIZE numeric 0 √ null
ED_PROCID int2 5 √ null
osl-tl_ed_procID.ED_PROCID <--ED_PROCID_from_osl-tl_ed_procID_fkey R
RESCOR varchar 3 √ null
DOSERECOV varchar 3 √ null
AGEMODELID int2 5 √ null
osl-tl_agemodelID.AGEMODELID <--AGEMODELID_from_osl-tl_agemodelID_fkey R
PH1_TEMP int2 5 √ null
PH2_TEMP int2 5 √ null
NUM_MEAS int2 5 √ null
NUM_ACC int2 5 √ null
EQUIVDOSE numeric 0 √ null
ED_ERR numeric 0 √ null
ED_INF varchar 3 √ null
OD numeric 0 √ null
OD_ERR numeric 0 √ null
OD_TYPE varchar 3 √ null
U numeric 0 √ null
U_ERR numeric 0 √ null
U_MTDID int2 5 √ null
osl-tl_mtdID.MTDID U_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
TH numeric 0 √ null
TH_ERR numeric 0 √ null
TH_MTDID int2 5 √ null
osl-tl_mtdID.MTDID TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
K numeric 0 √ null
K_ERR numeric 0 √ null
K_MTDID int2 5 √ null
osl-tl_mtdID.MTDID K_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
U238 numeric 0 √ null
U238_ERR numeric 0 √ null
RA226 numeric 0 √ null
RA226_ERR numeric 0 √ null
PB210 numeric 0 √ null
PB210_ERR numeric 0 √ null
RA228 numeric 0 √ null
RA228_ERR numeric 0 √ null
TH228 numeric 0 √ null
TH228_ERR numeric 0 √ null
TH232 numeric 0 √ null
TH232_ERR numeric 0 √ null
K40 numeric 0 √ null
K40_ERR numeric 0 √ null
ALPH numeric 0 √ null
ALPH_ERR numeric 0 √ null
ALPH_MTDID int2 5 √ null
osl-tl_mtdID.MTDID ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
BETA numeric 0 √ null
BETA_ERR numeric 0 √ null
BETA_MTDID int2 5 √ null
osl-tl_mtdID.MTDID BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
GAMMA numeric 0 √ null
GAMMA_ERR numeric 0 √ null
GMMA_MTDID int2 5 √ null
osl-tl_mtdID.MTDID GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
COSMIC numeric 0 √ null
COSMIC_ERR numeric 0 √ null
ALPH_I numeric 0 √ null
ALPH_I_ERR numeric 0 √ null
ALPH_I_MTD varchar 8 √ null
BETA_I numeric 0 √ null
BETA_I_ERR numeric 0 √ null
BETA_I_MTD varchar 8 √ null
DIFF_DOSE varchar 3 √ null
DOSERATE numeric 0 √ null
DOSE_ERR numeric 0 √ null
OSL_AGE numeric 0 √ null
OSL_RNDERR numeric 0 √ null
OSL_ERR numeric 0 √ null
AGE_CI varchar 2 √ null
FADCOR varchar 3 √ null
G_VAL numeric 0 √ null
G_VAL_ERR numeric 0 √ null
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_osl_DataCore_pkey Primary key Asc OBSID1

Relationships

Close relationships within degrees of separation