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_image_sha1

 * sha1 digest of the image

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_suggested_time

 * Timestamp reflecting the time the suggestion was entered or last shown for review. Stored as Unix format with milliseconds, converted to integer

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. Stored as Unix format with milliseconds, converted to integer

++--+--+-+-++ | Field             | Type             | Null | Key | Default | Extra          | ++--+--+-+-++ | mvl_id            | int(11)          | NO   | PRI | NULL    | auto_increment | | mvl_image_sha1    | varbinary(32)    | 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_suggested_time | binary(14)      | NO   | MUL | NULL    |                | | 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         |          59 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         0 | mvl_sha1_wikidata        |            1 | mvl_image_sha1     | A         |          19 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         0 | mvl_sha1_wikidata        |            2 | mvl_wikidata_id    | A         |          59 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         1 | mvl_review_sha1          |            1 | mvl_review         | A         |           4 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         1 | mvl_review_sha1          |            2 | mvl_image_sha1     | A         |          29 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         1 | mvl_sha1_review_uploader |            1 | mvl_review         | A         |           4 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         1 | mvl_sha1_review_uploader |            2 | mvl_uploader_id    | A         |           6 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_label |         1 | mvl_suggested_time       |            1 | mvl_suggested_time | A         |          19 |     NULL | NULL   |      | BTREE      |         |               | +--++--+--++---+-+--++--++-+---+