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       |       |