global_PubType

16 rows


Description

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_PubType stores publication types and is part of OCTOPUS reference system (= PUBTYPEID).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PUBTYPEID int2 5 null
global_RefCore.PUBTYPEID <--PUBTYPEID_from_global_PubType_fkey R
PUBTYPE 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_PubType_pkey Primary key Asc PUBTYPEID

Relationships