osl-tl_lum_matID

7 rows


Description

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the type of sample material used for OSL and TL dating (= LUM_MAT)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LUM_MATID smallserial 5 nextval('osl_tl_lum_matid_seq'::regclass)
arch_osl_DataCore.LUM_MATID <--LUM_MATID_from_osl-tl_lum_matID_fkey R
arch_tl_DataCore.LUM_MATID <--LUM_MATID_from_osl-tl_lum_matID_fkey R
sed-osl_DataCore.LUM_MATID <--LUM_MATID_from_osl-tl_lum_matID_fkey R
sed-tl_DataCore.LUM_MATID <--LUM_MATID_from_osl-tl_lum_matID_fkey R
LUM_MAT text 2147483647 null
LUM_MATABB 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_lum_matID_pkey Primary key Asc LUM_MATID
osl_tl_lum_matid_LUM_MAT_ukey Must be unique Asc LUM_MAT
osl_tl_lum_matid_LUM_MATABB_ukey Must be unique Asc LUM_MATABB

Relationships