wos_reprint_address_suborganizations

62860676 rows


Description

Suborganization Data from Addresses

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 2147483647 √ null
wos_reprint_addresses.id wos_reprint_address_suborganizations_id_addr_id_fkey C

WOS Record ID
addr_id int4 10 √ null
wos_reprint_addresses.addr_id wos_reprint_address_suborganizations_id_addr_id_fkey C

ID of parent reprint address
suborg_id int4 10 √ null

Order of suborganization record
suborganization varchar 2147483647 √ null

Suborganization

Indexes

Constraint Name Type Sort Column(s)
wos_reprint_address_suborganizations_id_addr_id_suborg_id_key Must be unique Asc/Asc/Asc id + addr_id + suborg_id

Relationships

Close relationships within degrees of separation