wos_summary

76656010 rows


Description

Summary Record Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 null
wos_abstracts.id wos_abstracts_id_fkey C
wos_addresses.id wos_addresses_id_fkey C
wos_book_desc.id wos_book_desc_id_fkey C
wos_book_notes.id wos_book_notes_id_fkey C
wos_conference.id wos_conference_id_fkey C
wos_contributors.id wos_contributors_id_fkey C
wos_doctypes.id wos_doctypes_id_fkey C
wos_dynamic_identifiers.id wos_dynamic_identifiers_id_fkey C
wos_edition.id wos_edition_id_fkey C
wos_grants.id wos_grants_id_fkey C
wos_headings.id wos_headings_id_fkey C
wos_keywords.id wos_keywords_id_fkey C
wos_keywords_plus.id wos_keywords_plus_id_fkey C
wos_languages.id wos_languages_id_fkey C
wos_normalized_doctypes.id wos_normalized_doctypes_id_fkey C
wos_normalized_languages.id wos_normalized_languages_id_fkey C
wos_page.id wos_page_id_fkey C
wos_publisher.id wos_publisher_id_fkey C
wos_references.id wos_references_id_fkey C
wos_reprint_addresses.id wos_reprint_addresses_id_fkey C
wos_reviewed_authors.id wos_reviewed_authors_id_fkey C
wos_reviewed_languages.id wos_reviewed_languages_id_fkey C
wos_subheadings.id wos_subheadings_id_fkey C
wos_subjects.id wos_subjects_id_fkey C
wos_summary_names.id wos_summary_names_id_fkey C
wos_titles.id wos_titles_id_fkey C

WOS Record ID
coll_id varchar 2147483647 √ null

Collection ID
pubyear varchar 2147483647 √ null

Publication year
pubmonth varchar 2147483647 √ null

Publication month
coverdate varchar 2147483647 √ null

Concatenation of pubyear and pubmonth
vol varchar 2147483647 √ null

Volume
issue varchar 2147483647 √ null

Issue
supplement varchar 2147483647 √ null

Journal Supplement
special_issue varchar 2147483647 √ null

Journal Special Issue
part_no varchar 2147483647 √ null

Journal part number
pubtype varchar 2147483647 √ null

Publication type
has_abstract varchar 2147483647 √ null

Whether abstract is available
sortdate varchar 2147483647 √ null

Undocumented
title_count varchar 2147483647 √ null

Number of source title variations
name_count varchar 2147483647 √ null

Name count
doctype_count varchar 2147483647 √ null

Document type count
conference_count varchar 2147483647 √ null

Conference count
language_count varchar 2147483647 √ null

Language count
normalized_language_count varchar 2147483647 √ null

Normalized language count
normalized_doctype_count varchar 2147483647 √ null

Normalized doctype count
reference_count varchar 2147483647 √ null

Reference count
address_count varchar 2147483647 √ null

Address count
headings_count varchar 2147483647 √ null

Heading count
subheadings_count varchar 2147483647 √ null

Subheading count
subjects_count varchar 2147483647 √ null

Subjects count
fund_ack varchar 2147483647 √ null

Text of funding acknowledgment
grants_count varchar 2147483647 √ null

Grant count
keyword_count varchar 2147483647 √ null

Keyword count
abstract_count varchar 2147483647 √ null

Abstract count
item_ids varchar 2147483647 √ null

ISI Document Solution identifier
item_ids_avail varchar 2147483647 √ null

IDS availability flag
bib_id varchar 2147483647 √ null

Concatenation of volume, issue, page span, date
bib_pagecount varchar 2147483647 √ null

Page count of source publication
bib_pagecount_type varchar 2147483647 √ null

Undocumented
reviewed_language_count varchar 2147483647 √ null

Count of languages of reviewed work
reviewed_author_count varchar 2147483647 √ null

Count of authors of reviewed work
reviewed_year varchar 2147483647 √ null

Reviewed work year
keywords_plus_count varchar 2147483647 √ null

Keywords plus count
book_chapters varchar 2147483647 √ null

Book chapter count
book_pages varchar 2147483647 √ null

Book pages
book_notes_count varchar 2147483647 √ null

Count of book notes
contributor_count varchar 2147483647 √ null

Contributor count

Indexes

Constraint Name Type Sort Column(s)
wos_summary_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation