wos_publisher

86053930 rows


Description

Summary Publisher Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 √ null
wos_publisher_names.id wos_publisher_names_id_publisher_id_fkey C
wos_summary.id wos_publisher_id_fkey C

WOS Record ID
publisher_id int4 10 √ null
wos_publisher_names.publisher_id wos_publisher_names_id_publisher_id_fkey C

Order of publisher record
addr_no varchar 2147483647 √ null

Address number. Used to link a specific author/publisher to a specific address.
full_address varchar 2147483647 √ null

Full address
city varchar 2147483647 √ null

City
name_count varchar 2147483647 √ null

Count of publisher names

Indexes

Constraint Name Type Sort Column(s)
idx_publisher_id Performance Asc publisher_id
wos_publisher_id_publisher_id_key Must be unique Asc/Asc id + publisher_id

Relationships

Close relationships within degrees of separation