osl-tl_ed_procID

7 rows


Description

Is Luminescence (SahulSed, SahulArch/ OSL collection, SahulArch/ TL collection) lookup table for the reported procedure used to determine sample equivalent dose for OSL and TL methods (= ED_PROC)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ED_PROCID smallserial 5 nextval('osl_tl_ed_procid_seq'::regclass)
arch_osl_DataCore.ED_PROCID <--ED_PROCID_from_osl-tl_ed_procID_fkey R
arch_tl_DataCore.ED_PROCID <--ED_PROCID_from_osl-tl_ed_procID_fkey R
sed-osl_DataCore.ED_PROCID <--ED_PROCID_from_osl-tl_ed_procID_fkey R
sed-tl_DataCore.ED_PROCID <--ED_PROCID_from_osl-tl_ed_procID_fkey R
ED_PROC text 2147483647 null
ED_PROCABR 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_ed_procID_pkey Primary key Asc ED_PROCID
osl_tl_ed_procid_ED_PROC_ukey Must be unique Asc ED_PROC
osl_tl_ed_procid_ED_PROCABR_ukey Must be unique Asc ED_PROCABR

Relationships