wos_addresses

133759370 rows


Description

Item Record Address Data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 √ null
wos_address_names.id wos_address_names_id_addr_id_fkey C
wos_address_organizations.id wos_address_organizations_id_addr_id_fkey C
wos_address_suborganizations.id wos_address_suborganizations_id_addr_id_fkey C
wos_address_zip.id wos_address_zip_id_addr_id_fkey C
wos_summary.id wos_addresses_id_fkey C

WOS Record ID
addr_id int4 10 √ null
wos_address_names.addr_id wos_address_names_id_addr_id_fkey C
wos_address_organizations.addr_id wos_address_organizations_id_addr_id_fkey C
wos_address_suborganizations.addr_id wos_address_suborganizations_id_addr_id_fkey C
wos_address_zip.addr_id wos_address_zip_id_addr_id_fkey C

Order of address 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
organization_count varchar 2147483647 √ null

Organizations count
suborganization_count varchar 2147483647 √ null

Suborganizations count
street varchar 2147483647 √ null

Street address
city varchar 2147483647 √ null

City
state varchar 2147483647 √ null

U.S. State or Canadian province
country varchar 2147483647 √ null

Country
name_count varchar 2147483647 √ null

Count of publisher names

Indexes

Constraint Name Type Sort Column(s)
idx_addr_id Performance Asc addr_id
wos_addresses_id_addr_id_key Must be unique Asc/Asc id + addr_id

Relationships

Close relationships within degrees of separation