add_zip_code

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
ins_inspection_address.zip_code_id fk_ins_inspection_address_on_zip_code R
ins_inspection_department_zip_code.zip_code_id fk_ins_inspection_department_zip_code_on_zip_code R
thirdp_base_third_party.zip_code_id fk_thirdp_base_third_party_on_zip_code R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
code varchar 255 null
search_key varchar 255 null
name varchar 255 √ null
description varchar 2048 √ null
sort_name varchar 255 √ null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_add_zip_code_on_best_confidence_origin R
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
city_id uuid 2147483647 null
add_city.id fk_add_zip_code_on_city R
geometry text 2147483647 √ null
color varchar 255 √ null
icon varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_add_zip_code Primary key Asc id
idx_add_zip_code_city Performance Asc city_id
idx_add_zip_code_unq Must be unique Asc/Asc/Asc/Asc code + search_key + name + city_id

Relationships

Close relationships within degrees of separation