global_RefCore

3947 rows


Description

Is OCTOPUS DB reference core table, i.e., global lookup table for references. global_RefCore stores all relevant reference information, which are linked via “REFDBID” field to compilation DataCore tables (= REFDBID).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
REFDBID text 2147483647 null
arch_c14_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
arch_c14_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
arch_c14_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
arch_c14_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
arch_osl_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
arch_osl_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
arch_osl_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
arch_osl_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
arch_tl_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
arch_tl_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
arch_tl_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
arch_tl_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
c14_calcurve.CALCURVREF <-- REFDBID_from_global_RefCore_fkey R
c14_calprogram.CALPROGREF <--REFDBID_from_global_RefCore_fkey R
char_DataCore.REFDBID1 <--REFDBID_for_REF1_from_global_RefCore_fkey R
char_DataCore.REFDBID2 <--REFDBID_for_REF2_from_global_RefCore_fkey R
char_DataCore.REFDBID3 <--REFDBID_for_REF3_from_global_RefCore_fkey R
crn_al_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
crn_be_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
expage_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
expage_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
expage_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
expage_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
fos_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
fos_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
fos_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
fos_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
global_datasetpublicationID.REFDBID <--REFDBID_from_global_RefCore_fkey R
global_UnitMaster.UNIT_REF <--REFDBID_from_global_RefCore_fkey R
sed-osl_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
sed-osl_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
sed-osl_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
sed-osl_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
sed-tl_DataCore.REFDBID1 <--REFDBID(1)_from_global_RefCore_fkey R
sed-tl_DataCore.REFDBID2 <--REFDBID(2)_from_global_RefCore_fkey R
sed-tl_DataCore.REFDBID3 <--REFDBID(3)_from_global_RefCore_fkey R
sed-tl_DataCore.REFDBID4 <--REFDBID(4)_from_global_RefCore_fkey R
global_RefKeyword.REFDBID <--REFDBID_from_global_RefKeyword_fkey R
global_RefAbstract.REFDBID <--REFDBID_from_global_RefAbstract_fkey R
OAID varchar 11 √ null
global_Author.OAID <--OAID_from_global_Author_fkey R
REFDOI text 2147483647 √ null
AUTHORS text 2147483647 √ null
TITLE text 2147483647 √ null
PUBTYPEID int2 5 null
global_PubType.PUBTYPEID <--PUBTYPEID_from_global_PubType_fkey R
JOURNALID int2 5 √ null
global_Journal.JOURNALID <--JOURNALID_from_global_Journal_fkey R
VOLUME text 2147483647 √ null
NUMBER text 2147483647 √ null
PAGES text 2147483647 √ null
YEAR int2 5 null
ADDRESS text 2147483647 √ null
NOTE text 2147483647 √ null
URL text 2147483647 √ null
BOOKTITLE text 2147483647 √ null
CHAPTER text 2147483647 √ null
EDITOR text 2147483647 √ null
PUBLISHER text 2147483647 √ null
INSTITUTION text 2147483647 √ null
SCHOOL 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
NEO_REFID int4 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation