geocode


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
date_entered DATETIME 19 null
date_modified DATETIME 19 null
deleted BIT 1 0
parent_id VARCHAR 36
parent_type VARCHAR 64
parent_name VARCHAR 256
parent_user_name VARCHAR 256
address TEXT 65535 null
status VARCHAR 100
postalcode VARCHAR 64
country VARCHAR 64
latitude DECIMAL 18,10 0.0000000000
longitude DECIMAL 18,10 0.0000000000
geocoded BIT 1 0
error_message TEXT 65535 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_coords_from_record Performance Asc/Asc/Asc/Asc parent_type + parent_id + geocoded + status
idx_coords_from_zip Performance Asc/Asc/Asc/Asc postalcode + country + geocoded + status
idx_geocode_country Performance Asc country
idx_geocode_del_d_e Performance Asc/Asc/Asc deleted + date_entered + id
idx_geocode_del_d_m Performance Asc/Asc/Asc deleted + date_modified + id
idx_geocode_geocoded Performance Asc/Asc geocoded + id
idx_geocode_id_del Performance Asc/Asc id + deleted
idx_geocode_lat_lng Performance Asc/Asc latitude + longitude
idx_geocode_p_i_id Performance Asc/Asc parent_id + id
idx_geocode_p_t_id Performance Asc/Asc parent_type + id
idx_geocode_postal_code Performance Asc postalcode
idx_geocode_status Performance Asc status

Relationships