cabah_chemprepID

37 rows


Description

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the type of chemical pretreatment given to an observation. Methods capture the majority of methods applied in Australia (= CHEMPREP).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CHEMPREPID int2 5 null
arch_c14_DataCore.CHEMPREPID <--CHEMPREPID_from_cabah_chemprepID_fkey R
fos_DataCore.CHEMPREPID <--CHEMPREPID_from_cabah_chemprepID_fkey R
CHEMPREP text 2147483647 null
CHEMPREPAB 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)
GLOBAL_chemprepID_pkey Primary key Asc CHEMPREPID
cabah_chemprepid_CHEMPREP_ukey Must be unique Asc CHEMPREP
cabah_chemprepid_CHEMPREPAB_ukey Must be unique Asc CHEMPREPAB

Relationships