Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | varchar | 2147483647 | √ | null |
|
|
WOS Record ID |
||||
| publisher_id | int4 | 10 | √ | null |
|
|
ID of parent publisher |
||||
| name_id | int4 | 10 | √ | null |
|
|
Order of name record |
||||
| role | varchar | 2147483647 | √ | null |
|
|
Role of the person or entity identified by th ename |
||||
| seq_no | varchar | 2147483647 | √ | null |
|
|
Sequence number of name in list |
||||
| addr_no_raw | varchar | 2147483647 | √ | null |
|
|
Raw address numbers, may be more than one separated by space |
||||
| display_name | varchar | 2147483647 | √ | null |
|
|
Name as displayed in record retrieved from database |
||||
| full_name | varchar | 2147483647 | √ | null |
|
|
Full name |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| wos_publisher_names_id_publisher_id_name_id_key | Must be unique | Asc/Asc/Asc | id + publisher_id + name_id |
Relationships
Close relationships within degrees of separation
