change application_count into text_type_coloumn