wos_summary_names

334887460 rows


Description

Name Data from Record Summary

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 √ null
wos_summary_names_email_addr.id wos_summary_names_email_addr_id_name_id_fkey C
wos_summary.id wos_summary_names_id_fkey C

WOS Record ID
name_id int4 10 √ null
wos_summary_names_email_addr.name_id wos_summary_names_email_addr_id_name_id_fkey C

Order of name record
role varchar 2147483647 √ null

Role of the person or entity identified by th ename
seq_no varchar 2147483647 √ null

Sequence number of name in list
addr_no_raw varchar 2147483647 √ null

Raw address numbers, may be more than one separated by space
reprint varchar 2147483647 √ null

Reprint author flag
lang_id varchar 2147483647 √ null

Language of the name
r_id varchar 2147483647 √ null

ResearcherID identifier
r_id_tr varchar 2147483647 √ null

ResearcherID identifier as captured by TR
orcid_id varchar 2147483647 √ null

ORCID identifier
orcid_id_tr varchar 2147483647 √ null

ORCID identifier as captured by TR
dais_id varchar 2147483647 √ null

Distinct Author Identification System identifier
display varchar 2147483647 √ null

Display flag used to indicate whether a name is displayed in full record.
display_name varchar 2147483647 √ null

Name as displayed in record retrieved from database
full_name varchar 2147483647 √ null

Full name
wos_standard varchar 2147483647 √ null

Name in Web of Science standard format
prefix varchar 2147483647 √ null

Name prefix
first_name varchar 2147483647 √ null

First (given) name
middle_name varchar 2147483647 √ null

Middle name
initials varchar 2147483647 √ null

Initials
last_name varchar 2147483647 √ null

Last name (surname)
suffix varchar 2147483647 √ null

Name suffix

Indexes

Constraint Name Type Sort Column(s)
wos_summary_names_id_name_id_key Must be unique Asc/Asc id + name_id

Relationships

Close relationships within degrees of separation