Extension:CheckUser/cu useragent clienthints map table/en

A table for the extension used to store the relationship between client hint rows in  table and one of, , or. Which of the three result tables a row references depends on the value of the  column. The table uses all three columns as a composite primary key.

uachm_uach_id
The ID of the row in the table that is associated with the row referenced in the   column.

uachm_reference_id
The ID of the row in one of the tables, , or that is associated with the client hint row referenced in. Which table that this column references is dependent on the value in the  column.

uachm_reference_type
A integer mapping identifier that specifies which of the tables, , or is referenced by the column. The valid mapping IDs for this column are stored in UserAgentClientHintsManager.php.

Schema
mysql> describe cu_useragent_clienthints_map; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field               | Type             | Null | Key | Default | Extra |
 * uachm_uach_id       | int(10) unsigned | NO   | PRI | NULL    |       |
 * uachm_reference_id  | int(10) unsigned | NO   | PRI | NULL    |       |
 * uachm_reference_type | tinyint(1)      | NO   | PRI | 0       |       |

Indexes
 mysql> show index in cu_useragent_clienthints_map; +--+++--+--+---+-+--++--++-+---+ +--+++--+--+---+-+--++--++-+---+ +--+++--+--+---+-+--++--++-+---+
 * Table                       | Non_unique | Key_name           | Seq_in_index | Column_name          | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * cu_useragent_clienthints_map |         0 | PRIMARY            |            1 | uachm_uach_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * cu_useragent_clienthints_map |         0 | PRIMARY            |            2 | uachm_reference_type | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * cu_useragent_clienthints_map |         0 | PRIMARY            |            3 | uachm_reference_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * cu_useragent_clienthints_map |         1 | uachm_reference_id |            1 | uachm_reference_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |