Extension:MachineVision/Schema/machine vision label

From MediaWiki.org
Jump to navigation Jump to search

Stores machine vision-generated labels, to be used as suggestions for "depicts" statements in SDC.

Fields[edit]

mvl_id[edit]

  • unique row ID

mvl_mvi_id[edit]

  • ID of the row in machine_vision_image that this label pertains to

mvl_wikidata_id[edit]

  • Wikidata ID (Q-number) identifying the item identified as depicted in the image

mvl_review[edit]

  • Review state represented as an integer, one of: 0 (unreviewed), 1 (accepted), -1 (rejected), -2 (skipped)

mvl_uploader_id[edit]

  • Local user ID of the user who uploaded the image

mvl_reviewer_id[edit]

  • Local user ID of the user who reviewed the label (if reviewed), or NULL if unreviewed

mvl_reviewed_time[edit]

  • Timestamp reflecting when the label was reviewed, or NULL if unreviewed.
+-------------------+------------------+------+-----+---------+----------------+
| Field             | Type             | Null | Key | Default | Extra          |
+-------------------+------------------+------+-----+---------+----------------+
| mvl_id            | int(11)          | NO   | PRI | NULL    | auto_increment |
| mvl_mvi_id        | int(11)          | NO   | MUL | NULL    |                |
| mvl_wikidata_id   | varbinary(32)    | NO   |     | NULL    |                |
| mvl_review        | tinyint(4)       | NO   | MUL | 0       |                |
| mvl_uploader_id   | int(10) unsigned | NO   |     | 0       |                |
| mvl_reviewer_id   | int(10) unsigned | YES  |     | NULL    |                |
| mvl_reviewed_time | binary(14)       | YES  |     | NULL    |                |
+-------------------+------------------+------+-----+---------+----------------+

Indexes[edit]

+----------------------+------------+---------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table                | Non_unique | Key_name            | Seq_in_index | Column_name     | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------------+------------+---------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| machine_vision_label |          0 | PRIMARY             |            1 | mvl_id          | A         |         131 |     NULL | NULL   |      | BTREE      |         |               |
| machine_vision_label |          0 | mvl_mvi_wikidata    |            1 | mvl_mvi_id      | A         |          32 |     NULL | NULL   |      | BTREE      |         |               |
| machine_vision_label |          0 | mvl_mvi_wikidata    |            2 | mvl_wikidata_id | A         |         131 |     NULL | NULL   |      | BTREE      |         |               |
| machine_vision_label |          1 | mvl_uploader_review |            1 | mvl_uploader_id | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| machine_vision_label |          1 | mvl_uploader_review |            2 | mvl_review      | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |
+----------------------+------------+---------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+