Extension:MachineVision/Schema/machine vision suggestion

From MediaWiki.org
Jump to navigation Jump to search

Stores incidental data regarding the suggestions stored in machine_vision_label, including the suggesting provider and any confidence score provided.

This is stored separately to reflect that more than one provider may provide the same suggested label (but with different confidence scores), but the suggestion should only be voted upon once.

Fields[edit]

mvs_mvl_id[edit]

  • unique row ID in machine_vision_label that this row refers to

mvs_provider_id[edit]

  • Numeric ID of the machine vision label provider

mvs_timestamp[edit]

  • Timestamp reflecting when the label was received

mvs_confidence[edit]

  • Confidence score provided with the label
+-----------------+------------------+------+-----+---------+-------+
| Field           | Type             | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------+-------+
| mvs_mvl_id      | int(11)          | NO   | PRI | NULL    |       |
| mvs_provider_id | int(10) unsigned | NO   | PRI | NULL    |       |
| mvs_timestamp   | binary(14)       | NO   |     | NULL    |       |
| mvs_confidence  | float unsigned   | NO   |     | 0       |       |
+-----------------+------------------+------+-----+---------+-------+

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_suggestion |          0 | PRIMARY  |            1 | mvs_mvl_id      | A         |          66 |     NULL | NULL   |      | BTREE      |         |               |
| machine_vision_suggestion |          0 | PRIMARY  |            2 | mvs_provider_id | A         |          66 |     NULL | NULL   |      | BTREE      |         |               |
+---------------------------+------------+----------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+