Extension:MachineVision/Schema/machine vision image

Stores SHA1 digests of images with associated label suggestions. A random value is stored for serving randomized suggestions.

mvi_id

 * unique row ID

mvi_sha1

 * SHA1 digest of the image

mvi_rand

 * Random float between 0 and 1

+--+---+--+-+-++ | Field   | Type          | Null | Key | Default | Extra          | +--+---+--+-+-++ | mvi_id  | int(11)       | NO   | PRI | NULL    | auto_increment | | mvi_sha1 | varbinary(32) | NO  | UNI | NULL    |                | | mvi_rand | float        | NO   | MUL | 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_image |         0 | PRIMARY  |            1 | mvi_id      | A         |          16 |     NULL | NULL   |      | BTREE      |         |               | | machine_vision_image |         0 | mvi_sha1 |            1 | mvi_sha1    | A         |          16 |       10 | NULL   |      | BTREE      |         |               | | machine_vision_image |         1 | mvi_rand |            1 | mvi_rand    | A         |          16 |     NULL | NULL   |      | BTREE      |         |               | +--++--+--+-+---+-+--++--++-+---+