Extension:MachineVision/Schema/machine vision label
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 | | |
+----------------------+------------+---------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+