Tables


SchemaSpy Analysis of wos.public

Generated on Fri Jul 19 07:34 EDT 2024

Web of Science SQL database

This is the documentation for the PostgreSQL database containing the data from the 2022 Web of Science XML dataset.

.

XML Representation
Insertion Order Deletion Order
TABLES 48
VIEWS 0
COLUMNS 318
Constraints 47
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.12 (Debian 14.12-1.pgdg110+1)

Tables

Table / View Children Parents Columns Rows Type Comments
wos_book_notes 0 1 3 16597573 Table

Book notes

wos_address_names_email_addr 0 3 5 62179012 Table

Email Data from Address Names

wos_reviewed_languages 0 1 3 2356976 Table

Item Record Language of Reviewed Work Data

wos_publisher 2 1 6 86053930 Table

Summary Publisher Data

wos_addresses 8 1 11 133759370 Table

Item Record Address Data

wos_conf_location 0 2 6 12542411 Table

Summary Conference Location Data

wos_page 0 1 6 87332890 Table

Pagination Data

wos_subheadings 0 1 3 78951856 Table

Subject category subheadings

wos_reprint_address_names 3 2 12 61046468 Table

Name Data from Reprint Addresses

wos_address_suborganizations 0 2 4 139159040 Table

Suborganization Data from Addresses

wos_conf_sponsor 0 2 4 35910796 Table

Summary Conference Sponsor Data

wos_contributors 0 1 10 73317150 Table

Contributors

wos_reprint_address_names_email_addr 0 3 5 34990568 Table

Email Data from Reprint Address Names

wos_address_organizations 0 2 4 293776540 Table

Organization Data from Addresses

wos_grants 6 1 5 49993724 Table

Grant Data

wos_keywords 0 1 3 161744460 Table

Keywords

wos_reprint_address_zip 0 2 5 50943132 Table

Zip Code Data from Reprint Addresses

wos_publisher_names 0 2 8 86589024 Table

Name Data from Publishers

wos_titles 0 1 4 496441150 Table

Title Data

wos_summary_names_email_addr 0 2 5 57001184 Table

Email Address Data from Record Summary

wos_reprint_addresses 8 1 11 60586036 Table

Item Record Reprint Address Data

wos_keywords_plus 0 1 3 226386320 Table

Keywords Plus. Keywords generated from the titles of cited references.

wos_headings 0 1 3 89770130 Table

High Level Subject Headings

wos_abstracts 2 1 3 43971928 Table

Abstracts

wos_reprint_address_suborganizations 0 2 4 62860676 Table

Suborganization Data from Addresses

wos_grant_agencies 0 2 5 90982824 Table

Grant agencies

wos_doctypes 0 1 3 91504370 Table

Summary Document Type Data

wos_normalized_doctypes 0 1 3 90965448 Table

Full Record Metadata Normalized Document Type Data

wos_subjects 0 1 4 261779340 Table

Subject categories

wos_book_desc 0 1 6 10996290 Table

Book description

wos_grant_ids 0 2 4 44472520 Table

Grant identifiers

wos_normalized_languages 0 1 4 86891024 Table

Full Record Metadata Normalized Language Data

wos_address_zip 0 2 5 90926192 Table

Zip Code Data from Addresses

wos_conf_title 0 2 4 12629294 Table

Summary Conference Title Data

wos_abstract_paragraphs 0 2 4 61402312 Table

Abstract paragraphs

wos_conference 10 1 8 12593049 Table

Summary Conference Data

wos_reviewed_authors 0 1 3 2967360 Table

Item Record Authors of Reviewed Work Data

wos_languages 0 1 4 86886016 Table

Full Record Metadata Language Data

wos_references 0 1 14 1876236160 Table

Reference Details

wos_address_names 3 2 15 213847810 Table

Name Data from Addresses

wos_summary_names 2 1 22 334887460 Table

Name Data from Record Summary

wos_summary 26 0 42 76656010 Table

Summary Record Data

wos_conf_info 0 2 4 12625458 Table

Summary Conference Info Data

wos_dynamic_identifiers 0 1 4 298230660 Table

Dynamically-defined Identifier Data

wos_conf_date 0 2 6 12592679 Table

Summary Conference Date Data

wos_reprint_address_organizations 0 2 4 130387024 Table

Organization Data from Reprint Addresses

wos_grant_data_items 0 2 11 2625669 Table

Grant data items

wos_edition 0 1 3 97605750 Table

Web of Science database editions