mysql> show indexes from File;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File  |          0 | PRIMARY  |            1 | FileId      | A         |     2355912 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId    |            1 | JobId       | A         |          17 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId_2  |            1 | JobId       | A         |          17 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId_2  |            2 | PathId      | A         |       58897 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId_2  |            3 | FilenameId  | A         |     2355912 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
5 rows in set (0.04 sec)