Extension:CheckUser/cusi case 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.

Primary key, used as the ID of a given case.

A integer representing the status of the case. Open is 0, Closed as resolved is 1, Closed as invalid is 2.

A reason given by the user that last made a change to the status of the case.

The timestamp when the case was created.

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.

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.

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

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

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

• Wikimedia extension database tables