osl-tl_mtdID

33 rows


Description

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the method used to determine a certain element concentration of the sample (= U_MTD, U_TH_MTD, TH_MTD, K_MTD) resp. the method used to determine an external dose rate (= ALPH_MTD, BETA_MTD, GAMMA_MTD)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
MTDID smallserial 5 √ nextval('osl_tl_mtdid_seq'::regclass)
arch_osl_DataCore.ALPH_MTDID ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_osl_DataCore.BETA_MTDID BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_osl_DataCore.GMMA_MTDID GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_osl_DataCore.K_MTDID K_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_osl_DataCore.TH_MTDID TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_osl_DataCore.U_MTDID U_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.ALPH_MTDID ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.BETA_MTDID BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.GMMA_MTDID GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.K_MTDID K_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.TH_MTDID TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.U_MTDID U_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
arch_tl_DataCore.U_TH_MTDID U_TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-osl_DataCore.ALPH_MTDID ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-osl_DataCore.BETA_MTDID BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-osl_DataCore.GMMA_MTDID GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-osl_DataCore.K_MTDID K_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-osl_DataCore.TH_MTDID TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-osl_DataCore.U_MTDID U_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.ALPH_MTDID ALPH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.BETA_MTDID BETA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.GMMA_MTDID GMMA_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.K_MTDID K_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.TH_MTDID TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.U_MTDID U_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
sed-tl_DataCore.U_TH_MTDID U_TH_MTDID<--MTDID_from_osl-tl_mtdID_fkey R
MTD text 2147483647 null
MTDAB 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)
osl-tl_mtdID_pkey Primary key Asc MTDID
osl_tl_mtdid_MTD_ukey Must be unique Asc MTD
osl_tl_mtdid_MTDAB_ukey Must be unique Asc MTDAB

Relationships

Close relationships within degrees of separation