geocode_job


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
status VARCHAR 64
processed_entity_success_count VARCHAR 64
processed_entity_failed_count VARCHAR 64
addresses_data LONGTEXT 2147483647 null
geocode_result LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_geocode_job_del_d_e Performance Asc/Asc/Asc deleted + date_entered + id
idx_geocode_job_del_d_m Performance Asc/Asc/Asc deleted + date_modified + id
idx_geocode_job_id_del Performance Asc/Asc id + deleted
idx_geocode_job_status Performance Asc/Asc status + id

Relationships