Extension:MachineVision/Schema/machine vision safe search

From MediaWiki.org
Jump to navigation Jump to search

Stores SafeSearch annotations.

Fields[edit]

mvss_image_sha1[edit]

  • Image SHA1 digest

mvss_adult[edit]

  • Likelihood the image depicts adult content. Likelihood is represented as an integer from 1 (very unlikely) to 5 (very unlikely), or 0 for unknown.

mvss_spoof[edit]

  • Likelihood the image is a "spoof." Likelihood is represented as an integer from 1 (very unlikely) to 5 (very unlikely), or 0 for unknown.

mvss_medical[edit]

  • Likelihood the image depicts medical content. Likelihood is represented as an integer from 1 (very unlikely) to 5 (very unlikely), or 0 for unknown.

mvss_violence[edit]

  • Likelihood the image depicts violence. Likelihood is represented as an integer from 1 (very unlikely) to 5 (very unlikely), or 0 for unknown.

mvss_racy[edit]

  • Likelihood the image is "racy." Likelihood is represented as an integer from 1 (very unlikely) to 5 (very unlikely), or 0 for unknown.
 +-----------------+---------------+------+-----+---------+-------+
 | Field           | Type          | Null | Key | Default | Extra |
 +-----------------+---------------+------+-----+---------+-------+
 | mvss_image_sha1 | varbinary(32) | NO   | PRI | NULL    |       |
 | mvss_adult      | tinyint(4)    | NO   |     | 0       |       |
 | mvss_spoof      | tinyint(4)    | NO   |     | 0       |       |
 | mvss_medical    | tinyint(4)    | NO   |     | 0       |       |
 | mvss_violence   | tinyint(4)    | NO   |     | 0       |       |
 | mvss_racy       | tinyint(4)    | 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_safe_search |          0 | PRIMARY  |            1 | mvss_image_sha1 | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 +----------------------------+------------+----------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+