Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | varchar | 2147483647 | √ | null |
|
|
WOS Record ID |
||||
addr_id | int4 | 10 | √ | null |
|
|
ID of parent reprint address |
||||
zip_id | int4 | 10 | √ | null |
|
|
Order of ZIP record |
||||
zip | varchar | 2147483647 | √ | null |
|
|
Zip code or postal code |
||||
location | varchar | 2147483647 | √ | null |
|
|
Undocumented |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
wos_reprint_address_zip_id_addr_id_zip_id_key | Must be unique | Asc/Asc/Asc | id + addr_id + zip_id |