created distance table in schema and updated association between distance & applications