global_RefAbstract

3962 rows


Description

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_RefAbstract stores publication abstracts 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_RefAbstract_fkey R
ABSTRACT 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_RefAbstract_pkey Primary key Asc REFDBID

Relationships