cabah_LabCodes

352 rows


Description

Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores information about the lab of origin for a certain observation. Labs have been identified automatically by their distinct labcode prefixes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LAB_ORIGID smallserial 5 √ nextval('cabah_lab_origid_seq'::regclass)
arch_c14_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
arch_osl_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
arch_tl_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
char_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
fos_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
sed-osl_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
sed-tl_DataCore.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey C
LAB_PREFIX text 2147483647 √ null
LAB_FACLTY text 2147483647 √ null
CNTRY varchar 3 √ null
LAB_ACTIVE bool 1 √ null
LAB_MTD varchar 50 √ null
LAB_URL text 2147483647 √ null
LAB_SOURCE 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_LabCodes_pkey Primary key Asc LAB_ORIGID

Relationships

Close relationships within degrees of separation