| product_matching_candidates | CREATE TABLE `product_matching_candidates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cache_source_pool_id` int(10) unsigned NOT NULL,
  `dist_id` varchar(255) NOT NULL,
  `alx_id` int(10) unsigned DEFAULT NULL,
  `alx_product_group_id` int(10) unsigned DEFAULT NULL,
  `trade_name` varchar(100) DEFAULT NULL,
  `species` varchar(100) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `standardized_description` text DEFAULT NULL,
  `mfg` varchar(255) DEFAULT NULL,
  `mfg_id` int(10) DEFAULT NULL,
  `mfg_sndx` varchar(50) GENERATED ALWAYS AS (soundex(`mfg`)) STORED,
  `mfg_product_code` varchar(255) DEFAULT NULL,
  `dose_ratio` decimal(10,2) DEFAULT NULL,
  `active` enum('N','Y') DEFAULT 'Y',
  PRIMARY KEY (`id`),
  KEY `cache_source_pool_id` (`cache_source_pool_id`),
  KEY `dist_id` (`dist_id`),
  KEY `description` (`description`),
  KEY `mfg` (`mfg`),
  KEY `mfg_sndx` (`mfg_sndx`),
  KEY `mfg_product_code` (`mfg_product_code`),
  KEY `alx_id` (`alx_id`),
  KEY `active` (`active`),
  FULLTEXT KEY `standardized_description` (`standardized_description`)
) ENGINE=MyISAM AUTO_INCREMENT=19395 DEFAULT CHARSET=latin1 |






MariaDB [pts]> SHOW INDEX IN product_matching_candidates;
+-----------------------------+------------+--------------------------+--------------+--------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table                       | Non_unique | Key_name                 | Seq_in_index | Column_name              | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------------------+------------+--------------------------+--------------+--------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| product_matching_candidates |          0 | PRIMARY                  |            1 | id                       | A         |       19394 |     NULL | NULL   |      | BTREE      |         |               |
| product_matching_candidates |          1 | cache_source_pool_id     |            1 | cache_source_pool_id     | A         |        NULL |     NULL | NULL   |      | BTREE      |         |               |
| product_matching_candidates |          1 | dist_id                  |            1 | dist_id                  | A         |        NULL |     NULL | NULL   |      | BTREE      |         |               |
| product_matching_candidates |          1 | description              |            1 | description              | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
| product_matching_candidates |          1 | mfg                      |            1 | mfg                      | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
| product_matching_candidates |          1 | mfg_sndx                 |            1 | mfg_sndx                 | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
| product_matching_candidates |          1 | mfg_product_code         |            1 | mfg_product_code         | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
| product_matching_candidates |          1 | alx_id                   |            1 | alx_id                   | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
| product_matching_candidates |          1 | active                   |            1 | active                   | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               |
| product_matching_candidates |          1 | standardized_description |            1 | standardized_description | NULL      |        NULL |     NULL | NULL   | YES  | FULLTEXT   |         |               |
+-----------------------------+------------+--------------------------+--------------+--------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
10 rows in set (0.00 sec)