wos_address_zip

90926192 rows


Description

Zip Code Data from Addresses

Columns

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

WOS Record ID
addr_id int4 10 √ null
wos_addresses.addr_id wos_address_zip_id_addr_id_fkey C

ID of parent 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)
idx_zip_id Performance Asc zip_id
wos_address_zip_id_addr_id_zip_id_key Must be unique Asc/Asc/Asc id + addr_id + zip_id

Relationships

Close relationships within degrees of separation