updated device_type column