cabah_col_mtdID

44 rows


Description

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the sample collection method (= COL_MTD).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
COL_MTDID smallserial 5 √ nextval('cabah_col_mtdid_seq'::regclass)
arch_c14_DataCore.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R
arch_osl_DataCore.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R
arch_tl_DataCore.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R
cabah_col_mtdID.PARENTID cabah_col_mtdid_fk R
global_UnitMaster.COLLECTID <--COL_MTDID_from_cabah_col_mtdID_fkey R
sed-osl_DataCore.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R
sed-tl_DataCore.COL_MTDID <--COL_MTDID_from_cabah_col_mtdID_fkey R
COL_MTD 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
PARENTID int2 5 √ null
cabah_col_mtdID.COL_MTDID cabah_col_mtdid_fk R

Indexes

Constraint Name Type Sort Column(s)
cabah_col_mtdID_pkey Primary key Asc COL_MTDID

Relationships

Close relationships within degrees of separation