global_RefKeyword

3973 rows


Description

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_RefKeyword is thoroughly boolean, stores compilation membership keywords for observations and is part of OCTOPUS reference system (= REFDBID; one to one).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
REFDBID text 2147483647 null
global_RefCore.REFDBID <--REFDBID_from_global_RefKeyword_fkey R
OCTOPUS bool 1 null
CRN bool 1 null
CRN_10BE bool 1 null
CRN_26AL bool 1 null
ARCH bool 1 null
ARCHC14_OP bool 1 null
ARCHC14_SL bool 1 null
ARCHOSL_OP bool 1 null
ARCHOSL_SL bool 1 null
ARCH_TL_OP bool 1 null
ARCH_TL_SL bool 1 null
EXPAGE bool 1 null
FOS bool 1 null
FOS_OP bool 1 null
FOS_SL bool 1 null
SED bool 1 null
SED-AEN bool 1 null
SED-FLV bool 1 null
SED-LAC bool 1 null
AEN_OSL_OP bool 1 null
AEN_OSL_SL bool 1 null
AEN_TL_OP bool 1 null
AEN_TL_SL bool 1 null
FLV_OSL_OP bool 1 null
FLV_OSL_SL bool 1 null
FLV_TL_OP bool 1 null
FLV_TL_SL bool 1 null
LAC_OSL_OP bool 1 null
LAC_OSL_SL bool 1 null
LAC_TL_OP bool 1 null
LAC_TL_SL bool 1 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
SHL_TRAITS bool 1 false
CST_OSL_OP bool 1 false
IPPD bool 1 false
ZAF_ARCH bool 1 false
SHL_CHAR bool 1 false
SHL_CHAR_OP bool 1 false
SHL_CHAR_SL bool 1 false
CST_OSL_SL bool 1 false
CST_TL_OP bool 1 false
CST_TL_SL bool 1 false

Indexes

Constraint Name Type Sort Column(s)
global_RefKeyword_pkey Primary key Asc REFDBID

Relationships

Close relationships within degrees of separation