It's not being used for anything.

Commit pushed to master at https://github.com/mozilla/treeherder https://github.com/mozilla/treeherder/commit/4196822599461e73bb3dd481a644c44cffe1cdae Bug 1211715 - Remove the device table

Before this is deployed, reference_data_signatures.device_name needs to be given a default (job.device_id already defaults to NULL). ALTER TABLE treeherder.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL; Run against Heroku: 16:28:35 ALTER TABLE treeherder.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL 0 row(s) affected Records: 0 Duplicates: 0 Warnings: 0 2.610 sec Stage: 16:48:02 ALTER TABLE treeherder_stage.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL 0 row(s) affected Records: 0 Duplicates: 0 Warnings: 0 0.156 sec Prod: 16:51:47 ALTER TABLE treeherder.reference_data_signatures CHANGE device_name device_name varchar(50) COLLATE utf8_bin DEFAULT NULL 0 row(s) affected Records: 0 Duplicates: 0 Warnings: 0 3.437 sec I'll file a separate bug to drop device table, reference_data_signatures.device_name and job.device_id.