Extension:CheckUser/cusi signal table
| MediaWiki version: | ≥ 1.45 |
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.
Fields
[edit]sis_sic_id
[edit]The ID of a row in the cusi_case table that this signal is associated with. Part of the composite primary key.
sis_name
[edit]Name of the signal that matched. Part of the composite primary key.
sis_value
[edit]A value associated with this signal match. Part of the composite primary key.
sis_trigger_id
[edit]| MediaWiki version: | ≥ 1.46 |
An ID associated with the signal match, which will be 0 if no ID is associated. Part of the composite primary key.
sis_trigger_type
[edit]| MediaWiki version: | ≥ 1.46 |
Integer mapping identifier specifying which table the ID in sis_trigger_id is associated with. Part of the composite primary key.
Schema
[edit]| MediaWiki version: | ≥ 1.46 |
DESCRIBE cusi_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 | | +------------------+---------------------+------+-----+---------+-------+
| MediaWiki version: | 1.45 |
DESCRIBE cusi_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 | | +------------+------------------+------+-----+---------+-------+
Indexes
[edit]SHOW INDEX IN cusi_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 | +-----------+------------+---------------------------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
