< Extension:MachineVision < Schema

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

mvs_mvl_id

  • unique row ID in machine_vision_label that this row refers to

mvs_provider_id

  • Numeric ID of the machine vision label provider

mvs_timestamp

  • Timestamp reflecting when the label was received

mvs_confidence

  • 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

+---------------------------+------------+----------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
 | 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      |         |               |
 +---------------------------+------------+----------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.