Extension:CheckUser/cusi signal table

A table for the CheckUser extension stored on the checkuser-virtual database domain.

This table is in a set of tables that begin with the cusi_ prefix which are used by the Suggested Investigations feature.

The ID of a row in the cusi_case table that this signal is associated with. Part of the composite primary key.

Name of the signal that matched. Part of the composite primary key.

A value associated with this signal match. Part of the composite primary key.

An ID associated with the signal match, which will be 0 if no ID is associated. Part of the composite primary key.

Integer mapping identifier specifying which table the ID in sis_trigger_id is associated with. Part of the composite primary key.

DESCRIBEcusi_signal;

+------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| sis_sic_id | int(10) unsigned | NO | PRI | NULL | |
| sis_name | varbinary(255) | NO | PRI | NULL | |
| sis_value | varbinary(255) | NO | PRI | NULL | |
| sis_trigger_id | bigint(20) unsigned | NO | PRI | 0 | |
| sis_trigger_type | tinyint(1) | NO | PRI | 0 | |
+------------------+---------------------+------+-----+---------+-------+

DESCRIBEcusi_signal;

+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| sis_sic_id | int(10) unsigned | NO | PRI | NULL | |
| sis_name | varbinary(255) | NO | PRI | NULL | |
| sis_value | varbinary(255) | NO | PRI | NULL | |
+------------+------------------+------+-----+---------+-------+

SHOWINDEXINcusi_signal;

+-----------+------------+---------------------------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-----------+------------+---------------------------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| cusi_case | 0 | PRIMARY | 1 | sic_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_status_created_timestamp_id | 1 | sic_status | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_status_created_timestamp_id | 2 | sic_created_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_status_created_timestamp_id | 3 | sic_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_created_timestamp_id | 1 | sic_created_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_created_timestamp_id | 2 | sic_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_url_identifier | 1 | sic_url_identifier | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_status_updated_timestamp_id | 1 | sic_status | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_status_updated_timestamp_id | 2 | sic_updated_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_status_updated_timestamp_id | 3 | sic_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_updated_timestamp_id | 1 | sic_updated_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| cusi_case | 0 | sic_updated_timestamp_id | 2 | sic_id | A | 0 | NULL | NULL | | BTREE | | | NO |
+-----------+------------+---------------------------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

• Wikimedia extension database tables