< Extension:MachineVision < Schema

Associates provider identifier strings with numeric IDs.

Fields

mv_provider_id

  • Numeric ID for the provider

mv_provider_name

  • Provider name
 +------------------+------------------+------+-----+---------+----------------+
 | Field            | Type             | Null | Key | Default | Extra          |
 +------------------+------------------+------+-----+---------+----------------+
 | mv_provider_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 | mv_provider_name | varbinary(255)   | NO   | UNI | 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_provider |          0 | PRIMARY  |            1 | mvp_id      | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
 | machine_vision_provider |          0 | mvp_name |            1 | mvp_name    | A         |           1 |     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.