Extension:MachineVision/Schema/machine vision label

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

mvl_id

 * unique row ID

mvl_mvi_id

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

mvl_wikidata_id

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

mvl_review

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

mvl_uploader_id

 * Local user ID of the user who uploaded the image

mvl_reviewer_id

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

mvl_reviewed_time

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