Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | varchar | 2147483647 | √ | null |
|
|
WOS Record ID |
||||
| ref_id | int4 | 10 | √ | null |
|
|
Order of reference record |
||||
| occurrence_order | int4 | 10 | √ | null |
|
|
Order of occurence in publication |
||||
| cited_id | varchar | 2147483647 | √ | null |
|
|
WoS Identifier of cited publication |
||||
| varchar | 2147483647 | √ | null |
|
|
Cited Author |
|||||
| assignee | varchar | 2147483647 | √ | null |
|
|
Assignee |
||||
| year | varchar | 2147483647 | √ | null |
|
|
Year |
||||
| page | varchar | 2147483647 | √ | null |
|
|
Page |
||||
| volume | varchar | 2147483647 | √ | null |
|
|
Volume |
||||
| cited_title | varchar | 2147483647 | √ | null |
|
|
Cited Title - Cited Title is only available is the cited reference clusters with a source item, or if a ‘full Cited Reference’ capture provided one |
||||
| cited_work | varchar | 2147483647 | √ | null |
|
|
Cited Work |
||||
| doi | varchar | 2147483647 | √ | null |
|
|
Digital Object Identifier |
||||
| art_no | varchar | 2147483647 | √ | null |
|
|
Undocumented |
||||
| patent_no | varchar | 2147483647 | √ | null |
|
|
Patent Number |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_cited_id | Performance | Asc | cited_id |
| idx_ref_id | Performance | Asc | ref_id |
| wos_references_id_ref_id_key | Must be unique | Asc/Asc | id + ref_id |
Relationships
Close relationships within degrees of separation
