Extension:CheckUser/cusi case 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
sic_id
Primary key, used as the ID of a given case.
sic_status
A integer representing the status of the case. Open is 0, Closed as resolved is 1, Closed as invalid is 2.
sic_status_reason
A reason given by the user that last made a change to the status of the case.
sic_created_timestamp
The timestamp when the case was created.
sic_url_identifier
| MediaWiki version: | ≥ 1.46 |
A identifier used as a hexadecimal string to represent the case in a URL. Randomly generated to avoid exposing the number of rows in this database table.
sic_updated_timestamp
| MediaWiki version: | ≥ 1.46 |
The last timestamp for when the case last matched a signal.
This timestamp is not updated when the case has it's sic_status or sic_status_reason columns updated.
Schema
| MediaWiki version: | ≥ 1.46 |
DESCRIBE cusi_case;
+-----------------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+----------------+----------------+ | sic_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | sic_status | tinyint(3) unsigned | NO | MUL | 0 | | | sic_status_reason | varbinary(255) | NO | | | | | sic_created_timestamp | binary(14) | NO | MUL | NULL | | | sic_url_identifier | int(10) unsigned | NO | UNI | NULL | | | sic_updated_timestamp | binary(14) | NO | MUL | NULL | | +-----------------------+---------------------+------+-----+----------------+----------------+
| MediaWiki version: | 1.45 |
DESCRIBE cusi_case;
+-----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+----------------+ | sic_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | sic_status | tinyint(3) unsigned | NO | MUL | 0 | | | sic_status_reason | varbinary(255) | NO | | | | | sic_created_timestamp | binary(14) | NO | MUL | NULL | | +-----------------------+---------------------+------+-----+---------+----------------+
Indexes
| MediaWiki version: | ≥ 1.46 |
SHOW INDEX IN cusi_case;
+-----------+------------+---------------------------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | 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_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 | +-----------+------------+---------------------------------+--------------+-----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------
