Extension:MachineVision/Schema/machine vision label

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

mv_label_id

 * unique row ID

mv_label_image_sha1

 * sha1 digest of the image

mv_label_provider_id

 * Numeric ID of the machine vision label provider

mv_label_wikidata_id

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

mv_nsfw_timestamp

 * Timestamp

Indices

 * Unique index on mv_label_image_sha1, mv_label_provider_id, mv_label_wikidata_id

+--+--+--+-+++ | Field               | Type             | Null | Key | Default        | Extra          | +--+--+--+-+++ | mv_label_id         | int              | NO   | PRI | NULL           | auto_increment | | mv_label_image_sha1 | varbinary(32)    | NO   | MUL | NULL           |                | | mv_label_provider_id | int(10) unsigned | NO  |     | NULL           |                | | mv_label_wikidata_id | varbinary(32)   | NO   |     | NULL           |                | | mv_label_timestamp  | binary(14)       | NO   |     | 19700101000000 |                | +--+--+--+-+++