global_Author

1733 rows


Description

Is parent table for global_RefCore table. The latter stores reference information for all compilations. global_Author stores information about first authors and is part of OCTOPUS reference system (= OAID).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OAID varchar 11 null
crn_aus_basins.OAID Implied Constraint R
crn_int_basins.OAID Implied Constraint R
crn_xxl_basins.OAID Implied Constraint R
global_RefCore.OAID <--OAID_from_global_Author_fkey R
ippd_datasets.OAID Implied Constraint R
ippd_datasets.PRME_OAID Implied Constraint R
neo_contacts.OAID <--OAID_from_global_Author_fkey R
sahulchar_units.OAID Implied Constraint R
AUTH text 2147483647 null

Is author family name
FORENAME text 2147483647 √ null
INITIALS text 2147483647 √ null
ORCID varchar 19 √ null

Is author ORCID (https://orcid.org). Is the preferred external author identifier
SCOPUSID text 2147483647 √ null

Is author Scopus ID (https://www.scopus.com/)
WSCC_RESID text 2147483647 √ null

Is Web of Science author ID (https://www.webofscience.com/wos/author/)
AUTH_COMMT 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
AUTH_URL text 2147483647 √ null

Is author url
URL_DATE date 13 √ null

Is date of latest author url validation

Indexes

Constraint Name Type Sort Column(s)
global_Author_pkey Primary key Asc OAID

Relationships

Close relationships within degrees of separation